From: Postmaster@druid.druid.com
Message-Id: <m0t7aBM-000RGMC@druid.druid.com>
Subject: Postgres95 on NetBSD
To: postgres95@postgres.Berkeley.EDU
Date: Mon, 23 Oct 1995 23:37:44 -0400 (EDT)
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Length: 1189      

Anyone doing this?  I have it up and running but it fails when I try
to enter more than 4000 items in one of the files.  The definition
is pretty simple:

CREATE TABLE connect (control int4, sys text, line text,
    start abstime, duration int4);
CREATE INDEX con_control ON connect USING btree (control int4_ops);
CREATE INDEX con_sys ON connect USING btree (sys text_ops);
CREATE INDEX con_start ON connect USING btree (start abstime_ops);

I don't have any rules specified for this table or the whole database
for that matter.  It doesn't matter whether I use SQL statements or
do a copy from statement.  It gets to almost 4000 and then hangs.
If I control-C out the backend (/usr/local/postgres/bin/postgres -p -Q -P4)
is still running.  from that point on I can't do anything with the DB.

If someone is working with large tables in NetBSD I would surely
appreciate any suggestions or war stories.

-- 
D'Arcy J.M. Cain (darcy@{druid.com|ican.ca}) |  Democracy is three wolves
D'Arcy Cain Consulting, Toronto, Canada      |  and a sheep voting on
+1 416 424 2871     (DoD#0082)    (eNTP)     |  what's for dinner.
    --  Home: http://www.druid.com/      Work: http://www.ican.ca  --
darcy