Search Postgresql Archives

Re: "Leaking" disk space on FreeBSD servers

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Dan Thomas <godders@xxxxxxxxx> wrote:

> We're seeing a problem with some of our FreeBSD/PostgreSQL
> servers "leaking" quite significant amounts of disk space:

> Stopping Postgres doesn't fix it, but rebooting does which points
> at the OS rather than PG to me. However, the leak is only
> apparent in the dedicated pgsql partition, and only on our
> database servers, so PostgreSQL seems to at least be involved.
> The partition itself is a relatively standard UFS partition:

I saw something once which *might* be related.  I don't recall the
OS of FS involved, but in an attempt to reduce the fragmentation of
files which started small and eventually grew large, a large
allocation of contiguous space was made on file creation, and that
space was not release as long as any page for the file remained in
the OS cache.  In the instance where I saw the problem, autovacuum
had been turned off and the instance was just coming up on the
point where wraparound prevention runs were about to be triggered. 
pg_clog was where most of the wasted space was.

No guarantees that this is the issue, but it sounded similar....

--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux