Re: Toasting more system-table columns

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Toasting more system-table columns
Дата
Msg-id 19269.965332667@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Toasting more system-table columns  ("Mark Hollomon" <mhh@nortelnetworks.com>)
Список pgsql-hackers
"Mark Hollomon" <mhh@nortelnetworks.com> writes:
> Tom Lane wrote:
>> pg_statistic to cope with long
>> min/max/common values (not sure about this).

> I would think pg_statistic would be a 'must'.

Well, it's not a "must" because the code copes fine now (there's a test
in there that simply drops pg_statistic tuples that won't fit).

Question is whether we need good selectivity estimation on columns where
the min/max/common values exceed 8K total (when represented in text form).
Or for that matter whether the estimates we derive from such values are
really useful ...
        regards, tom lane


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

Предыдущее
От: "Mark Hollomon"
Дата:
Сообщение: Re: Toasting more system-table columns
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: [BUGS] ALTER TABLE