Re: Postgres filling up hard drive with swap files

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgres filling up hard drive with swap files
Дата
Msg-id 2031.1093032494@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Postgres filling up hard drive with swap files  (Joe Lester <joe_lester@sweetwater.com>)
Список pgsql-general
Joe Lester <joe_lester@sweetwater.com> writes:
> And it's common for the clients to stay running for days at a time. I'd
> say the average length of a connection is 3 days.

Uh-huh.  Can you do anything to increase that?

Another possibility for slowing the leakage rate (pending a real fix)
is to decrease the size of your shared memory segment, ie, reduce
shared_buffers and the other shared-memory sizing parameters as much
as you can without killing performance.

            regards, tom lane

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

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: Postgres filling up hard drive with swap files
Следующее
От: Oliver Elphick
Дата:
Сообщение: Re: problem with postgresql-dump while upgrading to 7.4