| From: | Colleen Williams <colleen(at)digital-arts(dot)co(dot)uk> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | disk space usage by postgresql |
| Date: | 2001-03-08 11:06:30 |
| Message-ID: | 4.3.2.7.2.20010308105757.00b83f70@192.168.1.253 |
| Views: | Whole Thread | Raw Message | 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 is 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Colleen Williams | 2001-03-08 12:50:17 | freeing disk space used by postgresql/postmaster |
| Previous Message | hicham bouzdad | 2001-03-08 10:18:51 | Postgresql \z grant question |