Re: JDBC Performance
От | Joseph Shraibman |
---|---|
Тема | Re: JDBC Performance |
Дата | |
Msg-id | 3B73242B.7000500@selectacast.net обсуждение исходный текст |
Ответ на | JDBC Performance (<mike@mwcs.mb.ca>) |
Список | pgsql-jdbc |
This is typical. Until you do a vacuum the old versions of a row are still in the db, so an update has to do an index query on an index to get to the row that needs indexing, which returns a lot of pointers to old entries, that then have to be tranversed until the valid one in found. Then the update makes one more invalid row. mike@mwcs.mb.ca wrote: > I am having some performance problems with postgresql and JDBC when it > comes to updates. If I try and update a record it seems to be taking 1.7 > seconds for 100 records or 14 seconds for 500 records. An insert is only > taking between 3-5 ms/record. Performance on the updates continue to > decrease until I vacuum analyze the database again. Is this normal? > > Mike > > > > -- Joseph Shraibman jks@selectacast.net Increase signal to noise ratio. http://www.targabot.com
В списке pgsql-jdbc по дате отправления: