Re: Self-generating statistics?

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Self-generating statistics?
Дата
Msg-id 20021021090025.B14840@mail.libertyrms.com
обсуждение исходный текст
Ответ на Self-generating statistics?  (Mario Weilguni <mweilguni@sime.com>)
Список pgsql-performance
On Mon, Oct 21, 2002 at 08:23:33AM +0200, Mario Weilguni wrote:
> Something that might be worth considering:
>
> Many of the performance problems on pgsql-general seem to be
> related to the fact that no analyze is performed after the creation
> on the tables, so maybe this might be an option to fix that (in
> future releases): when a table has no statistics at all, and the
> first seq-scan on the table is

It's never the case that a table has no statistics at all.  It has
default ones.  Maybe they're right; it's hard to know.

Someone has posted on gborg an anto-vacuum daemon that might be of
use in this situation.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


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

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: Self-generating statistics?
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: Default cost variables in postgresql.conf