It is default value ( #checkpoint_segments = 3 # in logfile segments, min 1, 16MB each ) Many of my database configurations are default values. (plain TOAST etc) my database is a log database so, some tables of db grow everytime. My ' /base ' directory contains a lot of compressed object (1GB size) These are maybe normal operations but I don't understand that although I delete many rows from my db and regularly vacuum , reindexing operations, how doesn't postgresql give back that deleted areas for reusing.
Thom Brown wrote: > > On 26 May 2010 15:16, paladine <yasinma...@gmail.com> wrote: >> >> Hi all, >> >> How can I reduce disk space postgresql used ? >> I tried to delete many rows from my database and >> I am running ' vacuum analyze reindexdb ' commands regularly >> but my disk space on my linux machine didn't reduce. >> >> I know that ' vacuum full ' command can do that but I don't want to use >> that command because of the disadvantages. >> >> Anyone know another method ? >> >> Thanks in advance. >> -- >> View this message in context: >> http://old.nabble.com/reducing-postgresql-disk-space-tp28681415p28681415.html >> Sent from the PostgreSQL - general mailing list archive at Nabble.com. >> > > What have you got checkpoint_segments set to in your postgresql.conf > file? And how big is your database cluster? > > Thom > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > -- View this message in context: http://old.nabble.com/reducing-postgresql-disk-space-tp28681415p28681867.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
