Re: vacuum analyze again...

Поиск
Список
Период
Сортировка
Искать
От
Peter Eisentraut
Тема
Re: vacuum analyze again...
Дата
Msg-id
Pine.LNX.4.30.0102201900510.938-100000@peter.localdomain
Ответ на
Список
Дерево обсуждения
vacuum analyze again... Jean-Christophe Boggio <cat@thefreecat.org>
Re: vacuum analyze again... Bruce Momjian <pgman@candle.pha.pa.us>
Re: vacuum analyze again... Peter Eisentraut <peter_e@gmx.net>
Re: vacuum analyze again... Bruce Momjian <pgman@candle.pha.pa.us>
Re: vacuum analyze again... Tom Lane <tgl@sss.pgh.pa.us>
Re: vacuum analyze again... Bruce Momjian <pgman@candle.pha.pa.us>
Re: vacuum analyze again... Tom Lane <tgl@sss.pgh.pa.us>
Re: vacuum analyze again... Bruce Momjian <pgman@candle.pha.pa.us>
Bruce Momjian writes:

> No, we have no ability to randomly pick rows to use for estimating
> statistics.  Should we have this ability?

How's reading a sufficiently large fraction of random rows going to be
significantly faster than reading all rows?  If you're just going to read
the first n rows then that isn't really random, is it?

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/

В списке pgsql-general по дате отправления
От: Tom Lane
Дата:
От: Tressens Lionel
Дата:
FAQ