From: Tom Lane <tgl@sss.pgh.pa.us>
To: Matt Clark <matt@ymogen.net>
Cc: Andrew Sullivan <andrew@libertyrms.info>
Cc: pgsql-performance@postgresql.org
Subject: Re: reindex/vacuum locking/performance?
Date: Sun, 05 Oct 2003 14:07:13 -0400
Message-ID: <6652.1065377233@sss.pgh.pa.us> (raw)
In-Reply-To: <LFEIJBEOKGPDHCEMDGNFOEPMCFAA.matt@ymogen.net>
References: <LFEIJBEOKGPDHCEMDGNFOEPMCFAA.matt@ymogen.net>
"Matt Clark" <matt@ymogen.net> writes:
> OK, I had thought (wrongly it seems, as usual, but this is how we learn!)
> that a plain VACUUM did not incur a read of all pages. I still don't
> understand *why* it does, but I'll take your word for it.
Mainly 'cause it doesn't know where the dead tuples are till it's
looked. 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.
regards, tom lane
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: tgl@sss.pgh.pa.us, matt@ymogen.net, andrew@libertyrms.info
Subject: Re: reindex/vacuum locking/performance?
In-Reply-To: <6652.1065377233@sss.pgh.pa.us>
* 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