Re: storage calculations

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: storage calculations
Date: 2003-07-31 20:05:30
Message-ID: 20030731200529.GD16230@libertyrms.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Jul 31, 2003 at 01:41:54PM -0400, pgboy(at)guthrie(dot)charm(dot)net wrote:
>
> well, i was close. i didn't realize that i had to do a (non-full)
> vacuum to mark deleted space as free.

Ooops, I think I was still unclear. VACUUM FULL actually re-arranges
the file, and returns it to the filesystem. Plain VACUUM does indeed
leave you with a file that is bigger than the actual data stored
there.

You can learn how much more data you could fit in the files using
VACUUM VERBOSE, keeping in mind that tuples may not always fit in an
already-allocated page (like when the tuples are large).

> available until i do a full vacuum, correct? (at which time the
> file size(s) will indicate the amount being used)

That's right, yes.

> just started looking at fsm. thanks for the pointer there. i hope
> i'm not acting too obtuse here.

Nope. If you don't ask, you won't learn about it.

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mike Miller 2003-07-31 20:35:46 Standard Input Passwords?
Previous Message Priya Nair 2003-07-31 19:40:51 Recall: help needed for performance tuning