Postgres Pro
Downloads
Home   >   mailing lists

Re: Getting different number of results when using hashjoin on/off - Mailing list pgsql-hackers

From Mario Weilguni
Subject Re: Getting different number of results when using hashjoin on/off
Date
Msg-id 200511281421.49300.mweilguni@sime.com
Whole thread Raw
In response to Re: Getting different number of results when using hashjoin  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
Tree view 
Am Montag, 28. November 2005 14:12 schrieb Christopher Kings-Lynne:
> > The path field is an "ltree" column, with an GIST index on it.
>
> Something to do with bitmap indexscans on lossy indexes?
>
> Chris

I doubt that, "set enable_bitmapscan to off" produces the wrong result as 
well.

Best regards
Mario

pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Getting different number of results when using hashjoin
Next
From: Alvaro Herrera
Date:
Subject: What's wrong with the lists?