Re: ANALYZE versus expression indexes with nondefault opckeytype

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ANALYZE versus expression indexes with nondefault opckeytype
Дата
Msg-id 16565.1280678073@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: ANALYZE versus expression indexes with nondefault opckeytype  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: ANALYZE versus expression indexes with nondefault opckeytype  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: review: psql: edit function, show function commands patch
Следующее
От: Robert Haas
Дата:
Сообщение: Re: review: psql: edit function, show function commands patch