Re: postgres 8 performance
От | Paul Thomas |
---|---|
Тема | Re: postgres 8 performance |
Дата | |
Msg-id | 20040907120110.F29362@bacon обсуждение исходный текст |
Ответ на | postgres 8 performance (Paramveer.Singh@trilogy.com) |
Список | pgsql-general |
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 | +------------------------------+-------------------------------------------+
В списке pgsql-general по дате отправления: