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

From Tom Lane
Subject Re: Postgres filling up hard drive with swap files
Date
Msg-id 2031.1093032494@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgres filling up hard drive with swap files  (Joe Lester <joe_lester@sweetwater.com>)
List 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 by date:

Previous
From: Bill Moran
Date:
Subject: Re: Postgres filling up hard drive with swap files
Next
From: Oliver Elphick
Date:
Subject: Re: problem with postgresql-dump while upgrading to 7.4