Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #5328: GIN index with fastupdates=on provide wrong result on bitmap scan - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5328: GIN index with fastupdates=on provide wrong result on bitmap scan
Date
Msg-id 29593.1266335899@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5328: GIN index with fastupdates=on provide wrong result on bitmap scan  ("Maxim Boguk" <maxim.boguk@gmail.com>)
List pgsql-bugs
Tree view 
"Maxim Boguk" <maxim.boguk@gmail.com> writes:
> Bug reference:      5328
> Logged by:          Maxim Boguk
> Email address:      maxim.boguk@gmail.com
> PostgreSQL version: 8.4.1
> Operating system:   linux kernel v 2.6.18
> Description:        GIN index with fastupdates=on provide wrong result on
> bitmap scan

The 8.4.2 release notes mention

* Fix wrong search results for a multi-column GIN index with fastupdate enabled (Teodor)

which seems to match your complaint.  Please update and see if the
problem is resolved.  You might need to reindex the GIN index after
updating to make things good.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Maxim Boguk"
Date:
Subject: BUG #5328: GIN index with fastupdates=on provide wrong result on bitmap scan
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #5327: postgresql gives checksum error when upgrading 8.2.6 binaries to 8.2.14 in windows.