Re: Select max(foo) and select count(*) optimization

Поиск
Список
Период
Сортировка
От Shridhar Daithankar
Тема Re: Select max(foo) and select count(*) optimization
Дата
Msg-id 3FFAE2D8.6080301@persistent.co.in
обсуждение исходный текст
Ответ на Re: Select max(foo) and select count(*) optimization  (Robert Treat <xzilla@users.sourceforge.net>)
Список pgsql-performance
Robert Treat wrote:
> On Tue, 2004-01-06 at 07:20, Shridhar Daithankar wrote:

>>The numbers from pg_class are estimates updated by vacuum /analyze. Of course
>>you need to run vacuum frequent enough for that statistics to be updated all
>>the time or run autovacuum daemon..
>>Ran into same problem on my machine till I remembered about vacuum..:-)
> Actually you only need to run analyze to update the statistics.

Old habits die hard..:-)

  shridhar

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

Предыдущее
От: Robert Treat
Дата:
Сообщение: Re: Select max(foo) and select count(*) optimization
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Inefficient SELECT with OFFSET and LIMIT