Re: [JDBC] loading data into postgresql became slow - Mailing list pgsql-general

From Dave Cramer
Subject Re: [JDBC] loading data into postgresql became slow
Date
Msg-id 1083012124.13952.151.camel@localhost.localdomain
Whole thread Raw
In response to Re: loading data into postgresql became slow after i used VACUUME command.  ("Uwe C. Schroeder" <uwe@oss4u.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Eric Ridge
Date:
Subject: Re: Ordering YYYY MM DD in reverse chrono order
Next
From: "Glen Parker"
Date:
Subject: Re: shadowing (like IB/Firebird)