Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 30 Jun 2006 13:34:56 +0300
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
- Follow-Ups:
- Re: Index corruption
- From: Tom Lane
- Re: Index corruption
- References:
- Index corruption
- From: Marc Munro
- Re: Index corruption
- From: Tom Lane
- Re: Index corruption
- From: Marc Munro
- Re: Index corruption
- From: Tom Lane
- Index corruption
- Prev by Date: Re: Fixed length datatypes. WAS [GENERAL] UUID's as
- Next by Date: mailing list problem ?
- Previous by thread: Re: Index corruption
- Next by thread: Re: Index corruption
- Indexes: