Re: postgres 8 performance

On 07/09/2004 11:12 Paramveer.Singh@trilogy.com wrote:
> Hi all!
> I am running postgres 8 beta1 and for some reason it is really slow in
> execution. I am not able to figure out why.
> On a fresh install of postgres, the following code executed through jdbc
> 
> [snip]
> I can't figure out what the problem is.
> The app using jdbc and the postmaster instance were running on the same
> comp so I can't believe that communication would make that big a hit on
> performance.

Each of your JDBC inserts is being performed in a different transaction 
whilst your stored procedure is being executed is a single transaction. If 
you want to speed up the JDBC inserts, use setAutoCommit(false) on the 
connection object then do a connection.commit() at the end. If you really 
are taking 700 seconds, you've probably also got a network misconfiguration 
somewhere as well. 50-100 seconds would be more realistic even on fairly 
slow hardware. 

-- 
Paul Thomas
+------------------------------+-------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for Business           |
| Computer Consultants         | http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+-------------------------------------------+