Re: Why Does UPDATE Take So Long? - Mailing list pgsql-general

From Bill Thoen
Subject Re: Why Does UPDATE Take So Long?
Date
Msg-id 48E2A97F.7050204@gisnet.com
Whole thread Raw
In response to Re: Why Does UPDATE Take So Long?  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Why Does UPDATE Take So Long?  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: Why Does UPDATE Take So Long?
Next
From: Jeff Davis
Date:
Subject: Re: Why Does UPDATE Take So Long?