On Fri, Jan 12, 2007 at 09:45:28AM -0800, Mario Behring wrote:
> Simple question: once I execute the delete statement, does it free
> disk space immediatelly? Does Postgres uses something like a
> datafile with a pre-defined size like Oracle does??
What others said; but note that a vacuumed table
On Fri, 2007-01-12 at 11:45, Mario Behring wrote:
> Hi all,
>
> Simple question: once I execute the delete statement, does it free
> disk space immediatelly? Does Postgres uses something like a datafile
> with a pre-defined size like Oracle does??
>
Take a look here:
http://www.postgresql.org/do
> Thank you for your help.
>
> I am already running the vacuumdb full.after it finishes (I guess
> it will take a
> while to finish...) how should I execute this REINDEX ? Is there a single
> command to reindex the
> entire database?
Here is a link that describes its use:
http://www
---> Simple question: once I execute the delete statement, does it free disk
space immediatelly?
No. deleted rows (in a sense) are simply marked as deleted and are made
avaliable for being
written over by a new or updated tuple. If you want to recover the space you
can you TRUNCATE or
VACUUM
Hi all,
Simple question: once I execute the delete statement, does it free disk space
immediatelly? Does Postgres uses something like a datafile with a pre-defined
size like Oracle does??
Please advise.
Thank you.
Mario
___
