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 > [EMAIL PROTECTED] > > > > > > > > > -- Jeff Self Information Technology Analyst Department of Personnel City of Newport News 2400 Washington Ave. Newport News, VA 23607 757-926-6930 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
