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

От: Neil Conway
Тема: Re: [GENERAL] how to get accurate values in pg_statistic
Дата: ,
Msg-id: 1062719424.364.5.camel@tokyo
(см: обсуждение, исходный текст)
Ответ на: Re: [GENERAL] how to get accurate values in pg_statistic  (Rod Taylor)
Ответы: Re: [GENERAL] how to get accurate values in pg_statistic  (Mary Edie Meredith)
Re: [GENERAL] how to get accurate values in pg_statistic  (Rod Taylor)
Список: pgsql-performance

Скрыть дерево обсуждения

[GENERAL] how to get accurate values in pg_statistic (continued)  (Mary Edie Meredith, )
 Re: [GENERAL] how to get accurate values in pg_statistic  (Rod Taylor, )
  Re: [GENERAL] how to get accurate values in pg_statistic  (Neil Conway, )
   Re: [GENERAL] how to get accurate values in pg_statistic  (Mary Edie Meredith, )
   Re: [GENERAL] how to get accurate values in pg_statistic  (Rod Taylor, )
 Re: [GENERAL] how to get accurate values in pg_statistic (continued)  (Tom Lane, )
  Re: [GENERAL] how to get accurate values in pg_statistic  (Mary Edie Meredith, )
   Re: [GENERAL] how to get accurate values in pg_statistic  (Bruce Momjian, )
    Re: [GENERAL] how to get accurate values in pg_statistic  (Tom Lane, )
   Re: [GENERAL] how to get accurate values in pg_statistic  (Bruce Momjian, )
   Re: [GENERAL] how to get accurate values in pg_statistic  (Greg Stark, )
    Re: [GENERAL] how to get accurate values in pg_statistic  (Tom Lane, )
  Re: [GENERAL] how to get accurate values in pg_statistic (continued)  (Bruce Momjian, )
   Re: [osdldbt-general] Re: [GENERAL] how to get accurate  (Mary Edie Meredith, )
   Re: [osdldbt-general] Re: [GENERAL] how to get accurate  (Christopher Browne, )
  Re: [GENERAL] how to get accurate values in pg_statistic (continued)  (Christopher Browne, )
   Re: [GENERAL] how to get accurate values in pg_statistic (continued)  (Tom Lane, )
    Re: [GENERAL] how to get accurate values in pg_statistic  ("scott.marlowe", )
    Re: [GENERAL] how to get accurate values in pg_statistic  (Christopher Browne, )
     Re: [GENERAL] how to get accurate values in pg_statistic  ("scott.marlowe", )
 Re: [GENERAL] how to get accurate values in pg_statistic (continued)  (Tom Lane, )

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




В списке pgsql-performance по дате сообщения:

От: Eirik Oeverby
Дата:
Сообщение: Re: SELECT's take a long time compared to other DBMS
От: Richard Huxton
Дата:
Сообщение: Re: Performance problems on a fairly big table with two key columns.