freeing disk space used by postgresql/postmaster

From: Colleen Williams <colleen(at)digital-arts(dot)co(dot)uk>
To: pgsql-admin(at)postgresql(dot)org
Subject: freeing disk space used by postgresql/postmaster
Date: 2001-03-08 12:50:17
Message-ID: 4.3.2.7.2.20010308124857.02e4cea0@192.168.1.253
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)digital-arts(dot)co(dot)uk

0207 484 8825

Digital Arts | British Columbia House | 1 Regent Street | London | SW1Y 4NR
http://www.digital-arts.co.uk

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message pgsql-admin 2001-03-08 13:50:33 Re(2): Postgres/Postmaster logging and log rotation
Previous Message Colleen Williams 2001-03-08 11:06:30 disk space usage by postgresql