pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (37+ messages)  latest in thread

Message-ID: <LFEIJBEOKGPDHCEMDGNFAEPOCFAA.matt@ymogen.net>
Permalink:  ../LFEIJBEOKGPDHCEMDGNFAEPOCFAA.matt@ymogen.net/
Also on:    postgresql.org/message-id/LFEIJBEOKGPDHCEMDGNFAEPOCFAA.matt@ymogen.net

 · 

reply

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