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.