Consider upgrading to 7.4.x, 7.2.1 is quite old now. Dave On Mon, 2004-04-26 at 13:15, Uwe C. Schroeder wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > > Do a vacuum full, not just a vacuum. > > On Saturday 24 April 2004 10:13 pm, Simon Moses wrote: > > dear sir, > > i used to load 70 Mb flatfile data into postgresql database in less than 1 > > hour with my java code. two days back i gave VACUUME command and deleted > > all records with TRUNCATE command. now it is taking more than 3 hours to > > load same flatfile with same java programme. why it is so? and what to do > > to make it fast? > > i am using postgresql 7.2.1 in red hat linux 7.1 > > thanks in advance, > > Simon Moses, > > BANGALORE, INDIA. > > > > > > > > > > ********************************************************* > > Visit My Home Page updated: 20 June 2003. > > Simon Moses > > > > ********************************************************* > > > > > > > > --------------------------------- > > Do you Yahoo!? > > Yahoo! Photos: High-quality 4x6 digital prints for 25¢ > > - -- > UC > > - -- > Open Source Solutions 4U, LLC 2570 Fleetwood Drive > Phone: +1 650 872 2425 San Bruno, CA 94066 > Cell: +1 650 302 2405 United States > Fax: +1 650 872 2417 > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.2.3 (GNU/Linux) > > iD8DBQFAjUO1jqGXBvRToM4RAvNpAJ91Ivlt7/C1jhRTGTOW6hVe5LtCogCgwyfQ > jDxVI2SrWQtAy3Fs1drxV04= > =iGs+ > -----END PGP SIGNATURE----- > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > > > > !DSPAM:408d709e69192400311889! > > -- Dave Cramer 519 939 0336 ICQ # 14675561 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
