disk space usage by postgresql

Поиск
Список
Период
Сортировка
От Colleen Williams
Тема disk space usage by postgresql
Дата
Msg-id 4.3.2.7.2.20010308105757.00b83f70@192.168.1.253
обсуждение исходный текст
Список 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@digital-arts.co.uk

0207 484 8825

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


В списке pgsql-admin по дате отправления:

Предыдущее
От: root
Дата:
Сообщение: Re: Postgres/Postmaster logging and log rotation
Следующее
От: Marc Wrubleski
Дата:
Сообщение: Strange behavior with timestamps