Sender: owner-postgres95@postgres.Berkeley.EDU
X-Return-Path: andrew_yu
Received: from druid.druid.com (root@druid.com [205.206.14.17]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with SMTP id EAA19799 for <postgres95@nobozo.CS.Berkeley.EDU>; Wed, 1 Nov 1995 04:22:03 -0800
Received: by druid.druid.com (Smail3.1.28.1 #4)
	id m0tAcBX-000RFpC; Wed, 1 Nov 95 07:22 EST
Message-Id: <m0tAcBX-000RFpC@druid.druid.com>
From: darcy@druid.druid.com (D'Arcy J.M. Cain)
Subject: Postgres95 on NetBSD
To: postgres95@postgres.Berkeley.EDU
Date: Wed, 1 Nov 1995 07:22:27 -0500 (EST)
X-Mailer: ELM [version 2.4 PL24]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Length: 1189      
Resent-To: postgres95-redist
Resent-Date: Wed, 01 Nov 95 04:22:05 -0800
Resent-From: pglite
Resent-XMts: smtp

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  --

===============================================================================
  To unsubscribe from the Postgres95 mailing list, send mail with the subject
  line "DEL" to "postgres95-request@postgres.Berkeley.EDU". 
============  URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres95/  ===========
