Re: tsvector pg_stats seems quite a bit off.

Поиск
Список
Период
Сортировка
От Jesper Krogh
Тема Re: tsvector pg_stats seems quite a bit off.
Дата
Msg-id 4C03FC23.8000109@krogh.cc
обсуждение исходный текст
Ответ на Re: tsvector pg_stats seems quite a bit off.  (Jan Urbański <wulczer@wulczer.org>)
Ответы Re: tsvector pg_stats seems quite a bit off.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On 2010-05-30 20:02, Jan Urbański wrote:
> Here's a patch against recent git, but should apply to 8.4 sources as
> well. It would be interesting to measure the memory and time needed to
> analyse the table after applying it, because we will be now using a lot
> bigger bucket size and I haven't done any performance impact testing on
> it. I updated the initial comment block in compute_tsvector_stats, but
> the prose could probably be improved.
>    
Just a small follow up. I tried out the patch (or actually a fresh git
checkout) and it now gives very accurate results for both upper and
lower end of the MCE-histogram with a lower cutoff that doesn't
approach 2.

Thanks alot.

-- 
Jesper


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: 9.0b1: "ERROR: btree index keys must be ordered by attribute"
Следующее
От: Tom Lane
Дата:
Сообщение: Re: tsvector pg_stats seems quite a bit off.