Re: Postgres filling up hard drive with swap files

Поиск
Список
Период
Сортировка
От Joe Lester
Тема Re: Postgres filling up hard drive with swap files
Дата
Msg-id 540811EE-F2DF-11D8-BDD7-000A95A58EA0@sweetwater.com
обсуждение исходный текст
Ответ на Re: Postgres filling up hard drive with swap files  (Bill Moran <wmoran@potentialtech.com>)
Ответы Re: Postgres filling up hard drive with swap files  (Bill Moran <wmoran@potentialtech.com>)
Список pgsql-general
> If these clients aren't utilizing the database, it might be worthwhile
> to have them disconnect after a period of inactivity, and reconnect
> when
> things get busy again.

That's a good idea, except in the future, all the clients will be
active most of the time. So, I'd like to get the server to the point
where it can handle 150-200 client connections gracefully.

> I would expect that if you ignore it for a while, eventually it will
> reach an equalibrium.  (where it's not increasing the amount of swap in
> use) but it will always hurt performance any time is has to page in or
> out.

Unfortunately, it does not reach an equilibrium. It just keeps eating
disk space until it's all gone.

> Please don't wrap machine-generated output ... it makes it VERY
> difficult
> to understand.

Please forgive me. What do you mean by "wrap machine-generated output".
I would love to oblige.



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Postgres filling up hard drive with swap files
Следующее
От: Joe Lester
Дата:
Сообщение: Re: Postgres filling up hard drive with swap files