Re: Hash join on int takes 8..114 seconds

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Hash join on int takes 8..114 seconds
Дата
Msg-id 20081121202036.GK5210@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Hash join on int takes 8..114 seconds  ("Andrus" <kobruleht2@hot.ee>)
Список pgsql-performance
Andrus wrote:

>> So I gather you're not doing any vacuuming, eh?
>
> Log files for every day are full of garbage messages below.
> So I hope that vacuum is running well, isn't it ?

This does not really mean that autovacuum has done anything in the
databases.  If the times are consistently separated by 1 min, then it's
possible that it always exits without doing anything.

In such old a release we didn't have any decent logging mechanism in
autovacuum :-(  You can change log_min_messages to debug2 to see if it
actually does anything or not.

I suggest you connect to the problem database (and then to all others,
just to be sure) and run "vacuum" (no full).

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

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

Предыдущее
От: "Andrus"
Дата:
Сообщение: Re: Hash join on int takes 8..114 seconds
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: Hash join on int takes 8..114 seconds