Re: GIN indexscans versus equality selectivity estimation - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: GIN indexscans versus equality selectivity estimation
Date
Msg-id 4D2A5B86.8090502@agliodbs.com
Whole thread Raw
In response to GIN indexscans versus equality selectivity estimation  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 1/9/11 3:38 PM, Tom Lane wrote:
> 1. Do nothing.  The issue seems quite unlikely to affect anyone in the
> field, since in fact "use a seqscan" is probably the right answer
> anytime reltuples = 1; and anyway using a GIN index for plain equality
> is a corner case to begin with.  However, it could confuse people who
> were doing testing (it confused me!).

+1.  It's an unexpected result, but not actually a bad one.  It just
doesn't seem worth messing with code which works in production just to
help testing.

--                                  -- Josh Berkus                                    PostgreSQL Experts Inc.
                        http://www.pgexperts.com
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Compatibility GUC for serializable
Next
From: Robert Haas
Date:
Subject: Re: Compatibility GUC for serializable