-----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
