Skip site navigation (1) Skip section navigation (2)

Re: Postgres filling up hard drive with swap files

From: Joe Lester <joe_lester(at)sweetwater(dot)com>
To: postgres list <pgsql-general(at)postgresql(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Nader Nafissi <nader(at)apple(dot)com>
Subject: Re: Postgres filling up hard drive with swap files
Date: 2004-08-20 19:40:37
Message-ID: CF4861C4-F2E0-11D8-BDD7-000A95A58EA0@sweetwater.com (view raw or flat)
Thread:
Lists: pgsql-general
On Aug 20, 2004, at 2:28 PM, Tom Lane wrote:
> I think what you've found is an OS X bug.
>
> I was able to replicate this behavior on OS X 10.3.5.  All I did was
> start the postmaster and then start a continuous loop in a shell 
> window:
> 	while true
> 	do
> 		psql -c "select count(*) from tenk1" regression
> 	done
> (tenk1 is just a test table with 10000 or so rows ... not very big.)
> After a few thousand iterations I have more swapfiles than I did 
> before.
> The postmaster itself is certainly not leaking memory, and there are no
> backends lasting longer than a fraction of a second, but the machine is
> acting like it's got a problem.  Watching top, I see the "free PhysMem"
> steadily decrease to zero and then bounce back up to about 645M (out of
> 768M installed).  Each time it bounces up, the VM pageouts count takes 
> a
> jump (otherwise pageouts doesn't move), and there's also a burst of 
> disk
> activity according to iostat.  The cycle repeats every 45 seconds or 
> so.
> Meanwhile, the entire system has become exceedingly sluggish (opening
> Safari is painful, for example, and even just switching front
> application is visibly slow).

Yes, my system also becomes increasingly sluggish in the manner you 
describe as the swap files increase in number and size.

> Time to file a bug report.  With Apple, not with us.

I will. Thanks Tom!



In response to

pgsql-general by date

Next:From: Shelby CainDate: 2004-08-20 19:42:00
Subject: Re: Postgresql 8.0 beta 1 - strange cpu usage statistics and slow vacuuming
Previous:From: Joe LesterDate: 2004-08-20 19:30:00
Subject: Re: Postgres filling up hard drive with swap files

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group