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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
