Re: Fw: --fast switch - Mailing list pgsql-admin

From Jeff Self
Subject Re: Fw: --fast switch
Date
Msg-id 1015531140.1158.22.camel@personnel_test
Whole thread Raw
In response to Fw: --fast switch  (Jodi Kanter <jkanter@virginia.edu>)
List pgsql-admin
Are you talking about inserting a lot of data at one time? If so, drop
the index on the tables involved before inserting. You may also want to
turn fsync off as well.

On Thu, 2002-03-07 at 12:27, Jodi Kanter wrote:
> Did my message below make it out to the list? or is it that no one has any idea what I am referring to? If not, could
someonepoint me to ways to improve insertion time. I am vacuuming regularly. 
> thanks
> Jodi
>
> ----- Original Message -----
> From: Jodi Kanter
> To: Postgres Admin List
> Sent: Wednesday, March 06, 2002 11:33 AM
> Subject: --fast switch
>
>
> Can anyone offer me some insight into a --fast switch that can be used to improve speed on Poastgres inserts.
> I have been vacuuming database often but still our inserts seem to take quite a bit of time. Someone mentioned this
switchto me but I cannot seem to find any documentation on it. 
> thanks
> Jodi
> _______________________________
> Jodi L Kanter
> BioInformatics Database Administrator
> University of Virginia
> (434) 924-2846
> jkanter@virginia.edu
>
>
>
>
>
>
>
>
>
--
Jeff Self
Information Technology Analyst
Department of Personnel
City of Newport News
2400 Washington Ave.
Newport News, VA 23607
757-926-6930


pgsql-admin by date:

Previous
From: Joel Burton
Date:
Subject: Re: Dropped table screws referential integrity?
Next
From: "Zhang, Anna"
Date:
Subject: vacuum error