Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA15408; Wed, 31 Mar 93 22:30:06 -0800
Message-Id: <9304010630.AA15408@postgres.Berkeley.EDU>
From: mcquaig!nmm@uunet.UU.NET ("Neil M. McQuaig, III")
Subject: Re: Improving database load speed
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
In-Reply-To: Your message of "Wed, 31 Mar 93 08:29:07 CST."
             <9303311629.AA09160@postgres.Berkeley.EDU> 
Date: Thu, 01 Apr 93 00:11:46 CST
From: mcquaig!nmm@uunet.UU.NET ("Neil M. McQuaig, III")


> Currently it take over 2 minutes to load a test which is about 700
> instances. 

Are you perchance using a query containing the operator ~?
If so, is it perchance evaluating to find everything such as 
    where someattr~""\g

I had a similar problem an found that such a qualifier has disasterous
affects on throughput.

nmm