Database size stays constant but disk space keeps shrinking -- postgres 9.1

Поиск
Список
Период
Сортировка
Искать
От
Greg Williamson
Тема
Database size stays constant but disk space keeps shrinking -- postgres 9.1
Дата
Msg-id
1348783559.78739.YahooMailNeo@web125906.mail.ne1.yahoo.com
Список
Дерево обсуждения
Database size stays constant but disk space keeps shrinking -- postgres 9.1 Greg Williamson <gwilliamson39@yahoo.com>
Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1 Steve Crawford <scrawford@pinpointresearch.com>
Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1 Greg Williamson <gwilliamson39@yahoo.com>
Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1 Tom Lane <tgl@sss.pgh.pa.us>
Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1 Greg Williamson <gwilliamson39@yahoo.com>
Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1 Tom Lane <tgl@sss.pgh.pa.us>
Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1 Greg Williamson <gwilliamson39@yahoo.com>
Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1 Greg Williamson <gwilliamson39@yahoo.com>
Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1 Gabriele Bartolini <Gabriele.Bartolini@2ndQuadrant.it>
Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1 Greg Williamson <gwilliamson39@yahoo.com>
Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1 Jaime Casanova <jaime@2ndquadrant.com>
Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1 Greg Williamson <gwilliamson39@yahoo.com>
Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1 Jaime Casanova <jaime@2ndquadrant.com>
Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1 Dinesh Bhandary <bhandary@iii.com>
Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1 Greg Williamson <gwilliamson39@yahoo.com>
Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1 Steve Crawford <scrawford@pinpointresearch.com>
Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1 Greg Williamson <gwilliamson39@yahoo.com>
Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1 Tom Lane <tgl@sss.pgh.pa.us>
Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1 Dinesh Bhandary <dbhandary@iii.com>
Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1 Dinesh Bhandary <dbhandary@iii.com>
Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1 Micky Gough <mgough@squiz.com.au>
Dear list,

I have a postgres database, 9.1.3, which shows a fairly constant amount of space used by postgres, but total disk space kees shrinking.
If I restart postgres the space on my file system returns.

This cluster is replicated to another; that custer does not show this problem.

There are two main databases on this cluster, both using logging. One is used to accumulate some stats on our systen.

The other is a slimmed-down version of our production database, which gets recreated hourly by a shell script which pulls data from remote servers, does a pg_dump of the resulting 3 gig database, and then drops it.

I posted a message about ths a few days and got no responses. I am hoping for better luck this time as this is a serious issue,not relayed t vacuuming or routine admin tasks which may or may not be happening.

Thanks for any help / advice / things to look for.

Greg

a few details:
db11:5432=# select version();
                                                   version
--------------------------------------------------------------------------------------------------------------
 PostgreSQL 9.1.3 on x86_64-unknown-linux-gnu, compiled by gcc-4.4.real (Ubuntu 4.4.3-4ubuntu5) 4.4.3, 64-bit

Says one of our sysads:
"These are single disk systems. single no
n-raid sata. Using xfs as the filesystem like the rest of the dbs."

В списке pgsql-admin по дате отправления
От: Aras Targaryen
Дата:
От: Steve Crawford
Дата:
FAQ