Re: reducing postgresql disk space

On 26 May 2010 15:16, paladine <yasinmalli@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