Postgres Pro
Downloads
Home   >   mailing lists

loading data into postgresql became slow after i used VACUUME command. - Mailing list pgsql-general

From Simon Moses
Subject loading data into postgresql became slow after i used VACUUME command.
Date
Msg-id 20040425051301.54528.qmail@web14916.mail.yahoo.com
Whole thread Raw
Responses Re: loading data into postgresql became slow after i used VACUUME command.
List pgsql-general
Tree view
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�

pgsql-general by date:

Previous
From: Wes Palmer
Date:
Subject: Re: thread_test.c problems
Next
From: "Eric Comeau"
Date:
Subject: Re: Replication