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

From Alvaro Herrera
Subject Re: Postgres filling up hard drive with swap files
Date
Msg-id 20040820161526.GB5940@dcc.uchile.cl
Whole thread Raw
In response to Postgres filling up hard drive with swap files  (Joe Lester <joe_lester@sweetwater.com>)
Responses Re: Postgres filling up hard drive with swap files
List pgsql-general
On Fri, Aug 20, 2004 at 10:25:20AM -0500, Joe Lester wrote:
> This thread was renamed. It used to be: "shared_buffers Question".
> The old thread kind of died out. I'm hoping to get some more direction
> by rephrasing the problem, along with some extra observations I've
> recently made.
>
> The core of the problem is that Postgres is filling up my hard drive
> with swap files at the rate of around 3 to 7 GB per week (that's
> Gigabytes not Megabytes).

Maybe you said this before, but I didn't follow the previous thread.
What do you mean by swap files?  Where are those files located?  Can you
show a listing of them?

I assume, of course, that your data proper does not grow linearly with
those "swap files," does it?

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Si no sabes adonde vas, es muy probable que acabes en otra parte.


pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Log Clutter
Next
From: Tom Lane
Date:
Subject: Re: Log Clutter