Re: Index corruption

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: Index corruption
Дата
Msg-id 44A54455.1080700@Yahoo.com
обсуждение исходный текст
Ответ на Re: Index corruption  ("Marko Kreen" <markokr@gmail.com>)
Ответы Re: Index corruption  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On 6/30/2006 11:17 AM, Marko Kreen wrote:

> On 6/30/06, Jan Wieck <JanWieck@yahoo.com> wrote:
>> With the final implementation of log switching, the problem of xxid
>> wraparound will be avoided entirely. Every now and then slony will
>> switch from one to another log table and when the old one is drained and
>> logically empty, it is truncated, which should reinitialize all indexes.
> 
> If the xxid-s come from different DB-s, then there can still be problems.

How so? They are allways part of a multi-key index having the 
originating node ID first.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


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

Предыдущее
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: GIN index creation extremely slow ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Index corruption