Re: [GENERAL] how to get accurate values in pg_statistic

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: [GENERAL] how to get accurate values in pg_statistic
Дата
Msg-id 1062721750.89833.10.camel@jester
обсуждение исходный текст
Ответ на Re: [GENERAL] how to get accurate values in pg_statistic  (Neil Conway <neilc@samurai.com>)
Список pgsql-performance
Дерево обсуждения 
On Thu, 2003-09-04 at 19:50, Neil Conway wrote:
> On Thu, 2003-09-04 at 13:46, Rod Taylor wrote:
> > Run a VACUUM FULL ANALYZE between runs.  This will force a full scan of
> > all data for stats
>
> It will? Are you sure about that?

You're right. According to the docs it won't.

I had a poor stats issue on one table that was solved using that
command, coincidentally apparently.
Вложения

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

Предыдущее
От: Mary Edie Meredith
Дата:
Сообщение: Re: [GENERAL] how to get accurate values in pg_statistic
Следующее
От: "Relaxin"
Дата:
Сообщение: Re: SELECT's take a long time compared to other DBMS