Thread: memory bug

Hello, i have a problem related to the partition memory where postgres is i=
nstalled, this has increased so much that the partition is full and postgre=
s can not start up. The message postmaster sends when i want to restart is =
insuficient disk space. Do you know if postgres uses some disk space that m=
ay not releases.
                                                                           =
                                              Thanks in advance for your he=
lp...

Alexander Albarracin
CORE SECURITY TECHNOLOGIES
Florida 141 - 2=BA cuerpo - 7=BA piso
C1005AAC Buenos Aires - Argentina
Tel/Fax: (54 11) 5032-CORE (2673)
http://www.corest.com=

"Alex Albarracin" <aalbarracin@corest.com> writes:
> Hello, i have a problem related to the partition memory where
> postgres is installed, this has increased so much that the partition
> is full and postgres can not start up. The message postmaster sends
> when i want to restart is insuficient disk space. Do you know if
> postgres uses some disk space that may not releases.

Unused disk space is released by VACUUM FULL. If I understand your
situation correctly, I'd recommend temporarily adding some more disk
space or moving some data to another partition to allow the postmaster
to startup. Then you can reclaim some disk space using VACUUM FULL
and/or REINDEX. In the future, run VACUUM more frequently (and perhaps
bump max_fsm_pages).

-Neil