Re: Why Does UPDATE Take So Long?

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Bill Thoen <bthoen(at)gisnet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Why Does UPDATE Take So Long?
Date: 2008-09-30 22:37:37
Message-ID: 1222814257.6275.30.camel@dell.linuxdev.us.dell.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2008-09-30 at 16:34 -0600, Bill Thoen wrote:
> > Also, how many indexes does this table have?
> >
> >
> Two, but the column I'm updating isn't included in either one of them.
>

Even if the column is not indexed, when a new row is created (which is
the case with UPDATE) a new index entry must be made in each index to
point to the new row.

Regards,
Jeff Davis

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-09-30 23:03:33 Re: Why Does UPDATE Take So Long?
Previous Message Bill Thoen 2008-09-30 22:34:39 Re: Why Does UPDATE Take So Long?