Re: reindexing

From: Alex Hunsaker <badalex(at)gmail(dot)com>
To: akp geek <akpgeek(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: reindexing
Date: 2011-02-08 00:34:50
Message-ID: AANLkTikH4U7nSJZaT7kzZc3Pt2-rUkNYYRA8OCe1Pp0d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Feb 7, 2011 at 17:28, akp geek <akpgeek(at)gmail(dot)com> wrote:
> thanks.. the index I was having is gist on a to_tsvector column . version we
> have is 8.3

What minor version? I sounds like you _could_ be hitting any of the below:
- (8.3.14) Fix detection of page splits in temporary GiST indexes
(Heikki Linnakangas)
- (8.3.10) Fix incorrect WAL data emitted during end-of-recovery
cleanup of a GIST index page split
- (8.3.9) Fix incorrect logic for GiST index page splits, when the
split depends on a non-first column of the index (Paul Ramsey)
- (8.3.6) Fix whole-index GiST scans to work correctly (Teodor)
- (8.3.5) Fix GiST index corruption due to marking the wrong index
entry "dead" after a deletion (Teodor)

... I got bored of doing your homework after this point. :-(

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vinubalaji Gopal 2011-02-08 00:43:04 Re: tuning postgresql writes to disk
Previous Message akp geek 2011-02-08 00:28:50 Re: reindexing