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

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Artur Dabrowski <ad(at)astec(dot)com(dot)pl>, pgsql-hackers(at)postgresql(dot)org, Teodor Sigaev <teodor(at)sigaev(dot)ru>
Subject: Re: Query results differ depending on operating system (using GIN)
Date: 2010-07-21 09:20:47
Message-ID: Pine.LNX.4.64.1007211319340.32129@sn.sai.msu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 20 Jul 2010, Robert Haas wrote:

> 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...

On my machine I didn't reproduce the problem with Artur's dump. I think the
problem could be with package, since I use only compiled version.

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Abhijit Menon-Sen 2010-07-21 10:17:42 Re: managing git disk space usage
Previous Message Magnus Hagander 2010-07-21 09:03:33 Re: antisocial things you can do in git (but not CVS)