Re: ANALYZE versus expression indexes with nondefault opckeytype - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ANALYZE versus expression indexes with nondefault opckeytype
Date
Msg-id 16565.1280678073@sss.pgh.pa.us
Whole thread Raw
In response to Re: ANALYZE versus expression indexes with nondefault opckeytype  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: ANALYZE versus expression indexes with nondefault opckeytype  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Sat, Jul 31, 2010 at 11:15 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> I don't think this can be claimed to be a corner case. �If you set up
>> an FTS index according to the first alternative offered in
>> 
>> http://developer.postgresql.org/pgdocs/postgres/textsearch-tables.html#TEXTSEARCH-TABLES-INDEX
>> 
>> you will find that the system fails to collect stats for it and so you
>> get stupid default estimates for your FTS queries.

> Yeah, maybe you're right.  But I'd still prefer to see us break the
> ABI and do this just in 9.0 rather than changing 8.4.

OK, I can live with that.  I'll take a look at it shortly.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: review: psql: edit function, show function commands patch
Next
From: Robert Haas
Date:
Subject: Re: review: psql: edit function, show function commands patch