Re: DB is slow until DB is reloaded

Поиск
Список
Период
Сортировка
От Craig James
Тема Re: DB is slow until DB is reloaded
Дата
Msg-id 4B42B9C2.7050303@emolecules.com
обсуждение исходный текст
Ответ на Re: DB is slow until DB is reloaded  (Madison Kelly <linux@alteeve.com>)
Ответы Re: DB is slow until DB is reloaded  (Brad Nicholson <bnichols@ca.afilias.info>)
Список pgsql-performance
+Madison Kelly wrote:
> You are right, autovacuum is not running after all. From your comment, I
> am wondering if you'd recommend I turn it on or not? If so, given that I
> doubt I will upgrade any time soon, how would I enable it? I suppose I
> could google that, but google rarely shares gotcha's. :)

Most of the pain of a Postgres upgrade is the dump/reload step.  But you've already had to do that several times, so
whythe hesitation to upgrade?  Upgrading Postgres to the latest release, even if you have to do it from the source
code,takes almost no time at all compared to the time you've already burned trying to solve this problem.  Do the
upgrade,you won't regret it. 

Craig

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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: pg_connect takes 3.0 seconds
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_connect takes 3.0 seconds