| From: | Jeff Self <jself(at)nngov(dot)com> |
|---|---|
| To: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
| Cc: | Postgres Admin List <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Fw: --fast switch |
| Date: | 2002-03-07 19:59:00 |
| Message-ID: | 1015531140.1158.22.camel@personnel_test |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 someone point 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 switch to 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(at)virginia(dot)edu
>
>
>
>
>
>
>
>
>
--
Jeff Self
Information Technology Analyst
Department of Personnel
City of Newport News
2400 Washington Ave.
Newport News, VA 23607
757-926-6930
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tim Finch | 2002-03-07 21:13:41 | Re: [GENERAL] PGSTAT Error from Postmaster |
| Previous Message | Joel Burton | 2002-03-07 19:08:19 | Re: Dropped table screws referential integrity? |