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

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

From

Simon Moses

Date:

26 April 2004, 16:09:43

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�

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

From

"Uwe C. Schroeder"

Date:

26 April 2004, 20:12:26

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

Re: [JDBC] loading data into postgresql became slow

From

Dave Cramer

Date:

26 April 2004, 21:57:36

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