Re: very long update gin index troubles back?

Поиск
Список
Период
Сортировка
От Ivan Sergio Borgonovo
Тема Re: very long update gin index troubles back?
Дата
Msg-id 20090128211424.5a2e85ba@dawn.webthatworks.it
обсуждение исходный текст
Ответ на Re: very long update gin index troubles back?  (Teodor Sigaev <teodor@sigaev.ru>)
Ответы Re: very long update gin index troubles back?
Список pgsql-general
On Tue, 27 Jan 2009 20:45:53 +0300
Teodor Sigaev <teodor@sigaev.ru> wrote:

> > No matter if I drop the trigger that update agg content and the
> > fact that I'm just updating d, postgresql will update the index?
> Yes, due to MVCC. Update of row could produce new version (tuple)
> and new version should be index as old one.

Does that mean that it could be a good choice to place the tsvector
in another table?

thanks

--
Ivan Sergio Borgonovo
http://www.webthatworks.it


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

Предыдущее
От: Gabi Julien
Дата:
Сообщение: Re: Fwd: Re: New 8.4 hot standby feature
Следующее
От: Oleg Bartunov
Дата:
Сообщение: Re: very long update gin index troubles back?