From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Shridhar Polas <shridharpolas@gmail.com>
To: 'Kenneth Marshall' <ktm@rice.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: Space occupied by Postgres index.
Date: Tue, 30 Nov 2010 12:53:44 -0600
Message-ID: <4CF4F3D80200002500037F9E@gw.wicourts.gov> (raw)
In-Reply-To: <00c301cb90b5$f54b6370$dfe22a50$@gmail.com>
References: <00b901cb90b3$ca9ddc40$5fd994c0$@gmail.com>
<20101130172841.GK19162@aart.is.rice.edu>
<00c301cb90b5$f54b6370$dfe22a50$@gmail.com>
"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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, shridharpolas@gmail.com, ktm@rice.edu
Subject: Re: Space occupied by Postgres index.
In-Reply-To: <4CF4F3D80200002500037F9E@gw.wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox