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

Re: Index corruption

From: "Marko Kreen" <markokr(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Marc Munro" <marc(at)bloodnok(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Index corruption
Date: 2006-06-30 10:34:56
Message-ID: e51f66da0606300334q6c5f9252le4df64e7bde0d7dc@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On 6/30/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> I don't know the kernel nearly well enough to guess if these are related
> ...

The sl_log_* tables are indexed on xid, where the relations between
values are not exactly stable.  When having high enough activity on
one node or having nodes with XIDs on different enough positions
funny things happen.

Have you already excluded this as a probable reason?

-- 
marko

In response to

Responses

pgsql-hackers by date

Next:From: Marc G. FournierDate: 2006-06-30 13:19:21
Subject: Re: mailing list problem ?
Previous:From: Martijn van OosterhoutDate: 2006-06-30 10:13:26
Subject: Re: different sort order in windows and linux version

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