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

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 (view raw or flat)
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

pgsql-general by date

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

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