Richard Huxton wrote:
On 21/01/13 20:09, Tim Uckun wrote:

Just to close this up and give some guidance to future
Careful, future googlers.
Conclusion. Updates on postgres are slow
(given the default postgresql.conf). I presume this is due to
MVCC or the WAL or something and there are probably some things
I can do to tweak the conf file to make them go faster but out
of the box running an update on a table with lots of rows is
going to cost you a lot.
Unlikely. Do you really think that a PostgreSQL installation
typically runs 100 times slower on updates than inserts and every
other user has just said "oh, that's ok then"? Or is it more
likely that something peculiar is broken on your setup.
As someone who has managed hundreds of databases ranging up to over
3TB without seeing this without some very specific cause, I agree
that there is something wonky on Tim's setup which he hasn't told
us about. Then again, I'm not sure we've pushed hard enough for the
relevant details.

Tim, if you're still interested in resolving this, please post the
results from running the SQL code on this page:

It might be worthwhile to read through this page:

... and try some of the ideas there. Base disk perfromance numbers
would help put the results in perspective.

The cause could be anything from table bloat due to inadequate
vacuuming to hardware problems.


Search Discussions

Discussion Posts


Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 11 of 38 | next ›
Discussion Overview
grouppgsql-general @
postedJan 21, '13 at 8:04a
activeJan 27, '13 at 10:28a



site design / logo © 2021 Grokbase