Re: Why Does UPDATE Take So Long?

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: Why Does UPDATE Take So Long?
Дата
Msg-id 1222814257.6275.30.camel@dell.linuxdev.us.dell.com
обсуждение исходный текст
Ответ на Re: Why Does UPDATE Take So Long?  (Bill Thoen <bthoen@gisnet.com>)
Ответы Re: Why Does UPDATE Take So Long?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: Bill Thoen
Дата:
Сообщение: Re: Why Does UPDATE Take So Long?
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Why Does UPDATE Take So Long?