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
