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'
Re: update on TOAST status' |
Список | 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 по дате отправления: