Postgres Pro
Downloads
Home   >   mailing lists

Re: check point segments leakage ? - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: check point segments leakage ?
Date
Msg-id 1090432487.21450.31.camel@jester
Whole thread Raw
In response to Re: check point segments leakage ?  ("Matthew T. O'Connor" <matthew@zeut.net>)
Responses Re: check point segments leakage ?  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
Tree view 
> I don't know why the 1st VACUUM FULL wasn't able to reclaim the same 
> amount of space as the 2nd one, but I would guess that it wasn't able to 
> get a lock on some table.  It could have been autovac if it was doing a 
> vacuum at that moment, but it could have been something else too.

Or there was a long running transaction in the background. The oldest
active transaction will place limits on what VACUUM can or cannot
remove.

pgsql-hackers by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: check point segments leakage ?
Next
From: "Merlin Moncure"
Date:
Subject: parameter hints to the optimizer