Skip site navigation (1) Skip section navigation (2)

Re: Why Does UPDATE Take So Long?

From: Bill Thoen <bthoen(at)gisnet(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Why Does UPDATE Take So Long?
Date: 2008-09-30 22:34:39
Message-ID: 48E2A97F.7050204@gisnet.com (view raw or flat)
Thread:
Lists: 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.


In response to

Responses

pgsql-general by date

Next:From: Jeff DavisDate: 2008-09-30 22:37:37
Subject: Re: Why Does UPDATE Take So Long?
Previous:From: Alan HodgsonDate: 2008-09-30 22:20:09
Subject: Re: Why Does UPDATE Take So Long?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group