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

Поиск
Список
Период
Сортировка
От Mary Edie Meredith
Тема Re: [GENERAL] how to get accurate values in pg_statistic
Дата
Msg-id 1062720115.6854.3662.camel@ibm-e.pdx.osdl.net
обсуждение исходный текст
Ответ на Re: [GENERAL] how to get accurate values in pg_statistic  (Neil Conway <neilc@samurai.com>)
Список pgsql-performance
The documentation lead us to believe that it would not, but we are
testing just the same (at least checking that the pg_statistics are the
same after each load and VACUUM FULL ANALYZE).  Will report back.



On Thu, 2003-09-04 at 16: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?
>
> -Neil
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
--
Mary Edie Meredith <maryedie@osdl.org>
Open Source Development Lab


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

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: [GENERAL] how to get accurate values in pg_statistic
Следующее
От: Rod Taylor
Дата:
Сообщение: Re: [GENERAL] how to get accurate values in pg_statistic