Re: [JDBC] loading data into postgresql became slow

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: "Uwe C(dot) Schroeder" <uwe(at)oss4u(dot)com>
Cc: Simon Moses <ks_moses(at)yahoo(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: [JDBC] loading data into postgresql became slow
Date: 2004-04-26 20:42:04
Message-ID: 1083012124.13952.151.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Eric Ridge 2004-04-26 21:30:49 Re: Ordering YYYY MM DD in reverse chrono order
Previous Message Glen Parker 2004-04-26 20:25:59 Re: shadowing (like IB/Firebird)

Browse pgsql-jdbc by date

  From Date Subject
Next Message Jan de Visser 2004-04-26 21:36:34 Re: BLOBS
Previous Message Uwe C. Schroeder 2004-04-26 17:15:33 Re: loading data into postgresql became slow after i used VACUUME command.