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

Started by Simon Mosesalmost 22 years ago3 messagesgeneral

ks_moses@yahoo.com

almost 22 years ago

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

Uwe C. Schroeder

uwe@oss4u.com

almost 22 years ago

In reply to: Simon Moses (#1)

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

Dave Cramer

pg@fastcrypt.com

almost 22 years ago

In reply to: Uwe C. Schroeder (#2)

Re: [JDBC] loading data into postgresql became slow

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