Re: [BUGS] memory bug

#1

"Alex Albarracin" <aalbarracin (AT) corest (DOT) com> writes:

Quote:

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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] memory bug

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] memory bug - 11-24-2003 , 10:34 AM