Fw: --fast switch

Поиск
Список
Период
Сортировка
Искать

Fw: --fast switch

От:
Jodi Kanter <jkanter@virginia.edu>
Дата:
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 -----
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@virginia.edu


 

 

 

Re: Fw: --fast switch

От:
Jeff Self <jself@nngov.com>
Дата:
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@virginia.edu
> 
> 
> 
>  
> 
>  
> 
>  
> 
-- 
Jeff Self
Information Technology Analyst
Department of Personnel
City of Newport News
2400 Washington Ave.
Newport News, VA 23607
757-926-6930

FAQ