PG gets slower over time

Поиск
Список
Период
Сортировка
От Mike Diehl
Тема PG gets slower over time
Дата
Msg-id 200911031549.08771.mdiehl@diehlnet.com
обсуждение исходный текст
Ответы Re: PG gets slower over time
Список pgsql-general
Hi all.

I've got a database server that's been running for years now, but lately I've
had to restart it occasionally.

It seems to get slower and slower until I break down and restart it.  Then it
runs well.  (I vacuum regularly.)

It sounds to me like I've got some "stuck" connections, but I don't know how
to confirm this.  Any other suggestions would be welcome, also.

--

Take care and have fun,
Mike Diehl.

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

Предыдущее
От: Raymond O'Donnell
Дата:
Сообщение: Re: pg_dump on Linux with pg_restore on Windows?
Следующее
От: JP Fletcher
Дата:
Сообщение: auditing pg_hba.conf