Re: Incorrect FTS result with GIN index

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Artur Dabrowski <ad(at)astec(dot)com(dot)pl>, pgsql-general(at)postgresql(dot)org
Subject: Re: Incorrect FTS result with GIN index
Date: 2010-07-28 18:00:35
Message-ID: Pine.LNX.4.64.1007282200070.32129@sn.sai.msu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Tom,

you can download dump http://mira.sai.msu.su/~megera/tmp/search_tab.dump

Oleg
On Tue, 27 Jul 2010, Tom Lane wrote:

> Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> writes:
>> I recommend post your problem to -hackers mailing list. I have no idea,
>> what could be a problem.
>
> I wonder whether the problem is not windows versus non windows but
> original database versus copies. If it is a GIN bug it seems quite
> possible that it would depend on the order of insertion of the index
> entries, which a simple dump-and-reload probably wouldn't duplicate.
>
> If you were working from a dump it'd be easy to try creating the index
> before populating the table to see if the bug can be reproduced then,
> but there's no certainty that would provoke the bug.
>
> The rest of us have not seen the dump data, so we have no hope of
> doing anything with this report anyway.
>
> regards, tom lane
>
>

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2010-07-28 18:03:41 Re: Inheritance and trigger/FK propagation
Previous Message Merlin Moncure 2010-07-28 17:53:04 Re: Want FUNCTION to return argv[0] thru argv[6]

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-07-28 18:21:54 Re: page corruption on 8.3+ that makes it to standby
Previous Message Jeff Davis 2010-07-28 17:28:23 Re: page corruption on 8.3+ that makes it to standby