Re: loading data into postgresql became slow after i used VACUUME command.

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