From: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: deleting records from a table |
Date: | 2007-01-12 20:51:59 |
Message-ID: | 20070112205159.GA2806@phlogiston.dyndns.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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 that has a number of
now-empty slots can actually be a performance advantage, because new
rows don't need to increase the size of the table's on-disk file (so
you incur slightly less I/O). There's a "sweet spot" for this that
you can discover by testing.
A
--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
"The year's penultimate month" is not in truth a good way of saying
November.
--H.W. Fowler
From | Date | Subject | |
---|---|---|---|
Next Message | Ken | 2007-01-14 06:33:07 | update query taking 24+ hours |
Previous Message | Scott Marlowe | 2007-01-12 18:48:42 | Re: deleting records from a table |