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
