Re: tsvector pg_stats seems quite a bit off.

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: tsvector pg_stats seems quite a bit off.
Дата
Msg-id 1274812862-sup-7954@alvh.no-ip.org
обсуждение исходный текст
Ответ на tsvector pg_stats seems quite a bit off.  (Jesper Krogh <jesper@krogh.cc>)
Список pgsql-hackers
Excerpts from Jesper Krogh's message of mié may 19 15:01:18 -0400 2010:

> But the distribution is very "flat" at the end, the last 128 values are 
> excactly
> 1.00189e-05
> which means that any term sitting outside the array would get an estimate of
> 1.00189e-05 * 350174 / 2 = 1.75 ~ 2 rows

I don't know if this is related, but tsvector stats are computed and
stored per term, not per datum.  This is different from all other
datatypes.  Maybe there's code somewhere that's assuming per-datum and
coming up with the wrong estimates?  Or maybe the tsvector-specific code
contains a bug somewhere; maybe a rounding error?

-- 
Álvaro Herrera <alvherre@alvh.no-ip.org>


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

Предыдущее
От: Florian Pflug
Дата:
Сообщение: Re: Exposing the Xact commit order to the user
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Exposing the Xact commit order to the user