| From: | Simon Moses <ks_moses(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org |
| Subject: | loading data into postgresql became slow after i used VACUUME command. |
| Date: | 2004-04-25 05:13:01 |
| Message-ID: | 20040425051301.54528.qmail@web14916.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-jdbc |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | wespvp | 2004-04-25 05:16:06 | Re: thread_test.c problems |
| Previous Message | tech tech | 2004-04-25 04:18:22 | PostgreSQL 7.4.2 initdb problem |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Jowett | 2004-04-25 12:46:53 | Re: patch: streaming of bytea parameter values |
| Previous Message | Moray Taylor | 2004-04-25 00:03:40 | Re: Help:updateRow() with CIDR types |