Re: Simple join optimized badly?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Simple join optimized badly?
Дата
Msg-id 12915.1160349397@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Simple join optimized badly?  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
Josh Berkus <josh@agliodbs.com> writes:
> Now, if you were offering us a patch to auto-populate the statistics as a
> table is loaded, I'd be all for that.

Curiously enough, I was just thinking about that after reading Craig's
post.  autovacuum will do this, sort of, if it's turned on --- but its
reaction time is measured in minutes typically so that may not be good
enough.

Another thing we've been beat up about in the past is that loading a
pg_dump script doesn't ANALYZE the data afterward...

            regards, tom lane

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

Предыдущее
От: "Craig A. James"
Дата:
Сообщение: Re: Simple join optimized badly?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Simple join optimized badly?