Re: BUG #5328: GIN index with fastupdates=on provide wrong result on bitmap scan

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Maxim Boguk" <maxim(dot)boguk(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5328: GIN index with fastupdates=on provide wrong result on bitmap scan
Date: 2010-02-16 15:58:19
Message-ID: 29593.1266335899@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Maxim Boguk" <maxim(dot)boguk(at)gmail(dot)com> writes:
> Bug reference: 5328
> Logged by: Maxim Boguk
> Email address: maxim(dot)boguk(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2010-02-16 16:59:57 Re: BUG #5327: postgresql gives checksum error when upgrading 8.2.6 binaries to 8.2.14 in windows.
Previous Message Olivier Jeannet 2010-02-16 15:06:35 BUG #5329: postmaster fails to start because of an erroneous pg_hba.conf, but doesn't output any error