Search Postgresql Archives

Re: PostgreSQL Performance issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I am curious to know how much of your delay is due to PostgreSQL and how much to your Java batch program.  If you comment out the call to the database function, so that you are reading your input file but not doing anything with the data, how long does your batch program take to run?

 

RobR

 

--

The Java program hardly takes a minute to process all the flat files but at the time inserting the records into the db, the entire process takes more than 4 hours.

 

Many thanks

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux