Re: Why Does UPDATE Take So Long?

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.