Alvaro Herrera wrote:
Bill Moran wrote:
What I suspect is that the typical tuning advice applies here. I don't
see any information about your configuration or your hardware setup.
* What are shared_buffers set at?
* What do the checkpoint configs look like?
* In general, what does your postgresql.conf look like, how much tuning
have you done?
* What is your hardware setup? You're not running RAID 5 are you?
Also, how many indexes does this table have?
Two, but the column I'm updating isn't included in either one of them.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general