Обсуждение: freeing disk space used by postgresql/postmaster
Hi We are experiencing this scenario - 1. at the point postgresql (postmaster) is stopped and restarted the disk usage was 56% (277336 blocks) 2. after about 2 days the disk usage is 69% (339528 blocks)... after about 1 week it goes up to 100% 3. after stopping and restarting postgresql (postmaster) again the disk usage is back to 56% Do we need to start and stop postgresql regularly to free up disk space - is this normal? I vacuum the databases regularly but this does not seem to make any difference. Many Thanks, Colleen. Colleen Williams colleen@digital-arts.co.uk 0207 484 8825 Digital Arts | British Columbia House | 1 Regent Street | London | SW1Y 4NR http://www.digital-arts.co.uk
Colleen Williams <colleen@digital-arts.co.uk> writes: > 3. after stopping and restarting postgresql (postmaster) again the disk > usage is back to 56% Oh? Stopping and restarting the postmaster shouldn't make any difference as far as postgres itself is concerned. May I ask what you are doing with the postmaster log (stdout & stderr)? How high do you have the debug level set? regards, tom lane