Re: Query results differ depending on operating system (using GIN)

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Artur Dabrowski <ad(at)astec(dot)com(dot)pl>
Cc: pgsql-hackers(at)postgresql(dot)org, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, Teodor Sigaev <teodor(at)sigaev(dot)ru>
Subject: Re: Query results differ depending on operating system (using GIN)
Date: 2010-07-20 14:22:23
Message-ID: AANLkTikbXj84QLiQzbAsJmA=fVm0Oy2ibC+Eqmp6=7M-@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jul 20, 2010 at 5:41 AM, Artur Dabrowski <ad(at)astec(dot)com(dot)pl> wrote:
> I have been redirected here from pg-general.
>
> I tested full text search using GIN index and it turned out that the results
> depend on operating system. Not all the rows are found when executing some
> of queries on pg server installed on Win XP SP3 and CentOS 5.4, while
> everything seems to be fine on Ubuntu 4.4.1.
>
> More details and tested queries are described here:
> http://old.nabble.com/Incorrect-FTS-results-with-GIN-index-ts29172750.html
>
> I hope you can help with this weird problem.

This seems like it's definitely a bug, but I don't know much about the
GIN code. Copying Oleg and Teodor...

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2010-07-20 14:31:01 Re: Query optimization problem
Previous Message Robert Haas 2010-07-20 14:14:51 Re: psql \conninfo command (was: Patch: psql \whoami option)