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
