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