Re: [SQL] 7.3 analyze & vacuum analyze problem

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: [SQL] 7.3 analyze & vacuum analyze problem
Дата
Msg-id 0a1301c30f84$39a2dbe0$6500a8c0@fhp.internal
обсуждение исходный текст
Ответ на Re: [SQL] 7.3 analyze & vacuum analyze problem  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Список pgsql-performance
> > I am afraid it is not so simple.
> > What i (unsuccessfully) implied is that
> > dynacom=# VACUUM ANALYZE status ;
> > VACUUM
> > dynacom=# ANALYZE status ;
> > ANALYZE
> > dynacom=#
>
> You're right, that is mysterious.   If you don't get a response from one
of
> the major developers on this forum, I suggest that you post those EXPLAIN
> results to PGSQL-BUGS.

Is it mysterious?  The ANALYZE histogram algorithm does do random sampling
doesn't it?

Chris


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] 7.3 analyze & vacuum analyze problem
Следующее
От: Rajesh Kumar Mallah
Дата:
Сообщение: Re: profiling plpgsql functions..