From: Matt Clark <matt@ymogen.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Andrew Sullivan <andrew@libertyrms.info>
Cc: pgsql-performance@postgresql.org
Subject: Re: reindex/vacuum locking/performance?
Date: Sun, 5 Oct 2003 19:43:17 +0100
Message-ID: <LFEIJBEOKGPDHCEMDGNFAEPOCFAA.matt@ymogen.net> (raw)
In-Reply-To: <6652.1065377233@sss.pgh.pa.us>
> Mainly 'cause it doesn't know where the dead tuples are till it's
> looked.
At this point I feel very stupid...
> Also, VACUUM is the data collector for the free space map,
> and so it is also charged with finding out how much free space exists
> on every page.
Ah, now I just feel enlightened! That makes perfect sense. I think I had
been conflating free pages with free space, without understanding what the
difference was. Of course I still don't really understand, but at least I
now _know_ I don't.
Many thanks
Matt
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-performance@postgresql.org
Cc: matt@ymogen.net, tgl@sss.pgh.pa.us, andrew@libertyrms.info
Subject: Re: reindex/vacuum locking/performance?
In-Reply-To: <LFEIJBEOKGPDHCEMDGNFAEPOCFAA.matt@ymogen.net>
* 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