Re: update on TOAST status'

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: update on TOAST status'
Дата
Msg-id 200007062029.QAA11590@candle.pha.pa.us
обсуждение исходный текст
Ответ на update on TOAST status  (JanWieck@t-online.de (Jan Wieck))
Ответы Re: update on TOAST status'  (JanWieck@t-online.de (Jan Wieck))
Re: update on TOAST status'  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
>     -   VACUUM  doesn't  propagate  ANALYZE  to   TOAST   tables.
>         Statistics for them are needless because the toast access
>         is allways hardcoded indexed.

I don't think statistics are insignificant for TOASTed columns.  If I
say col=3, the optimizer uses that information for estimating the number
of rows returned, and figuring out the type of join and order of join to
perform, not just for "use index, don't use index" decisions.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


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

Предыдущее
От: JanWieck@t-online.de (Jan Wieck)
Дата:
Сообщение: Re: Fix for pg_dump
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: 2nd update on TOAST