Re: Postgres filling up hard drive with swap files - Mailing list pgsql-general

From Joe Lester
Subject Re: Postgres filling up hard drive with swap files
Date
Msg-id 540811EE-F2DF-11D8-BDD7-000A95A58EA0@sweetwater.com
Whole thread Raw
In response to Re: Postgres filling up hard drive with swap files  (Bill Moran <wmoran@potentialtech.com>)
Responses Re: Postgres filling up hard drive with swap files  (Bill Moran <wmoran@potentialtech.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgres filling up hard drive with swap files
Next
From: Joe Lester
Date:
Subject: Re: Postgres filling up hard drive with swap files