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
