[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] Space occupied by Postgres index.
From:       "Kevin Grittner" <Kevin.Grittner () wicourts ! gov>
Date:       2010-11-30 18:53:44
Message-ID: 4CF4F3D80200002500037F9E () gw ! wicourts ! gov
[Download RAW message or body]

"Shridhar Polas" <shridharpolas@gmail.com> wrote:
 
> In my test setup I found that the disk space consumed by Postgers
> is not getting declined even after deleting records from tables,
> if I do not perform VACUUM FULL and REINDEX.
 
True, but if you expect the tables to grow again it's generally
better to leave the space allocated to PostgreSQL than to make it
give it back up to the OS for the moment and have to go ask for it
again later.
 
If you don't expect PostgreSQL to need the space again and you want
to release it back to the OS, prior to release 9.0 it is usually
better to use CLUSTER than to use VACUUM FULL and REINDEX.
 
-Kevin

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
[prev in list] [next in list] [prev in thread] [next in thread]