From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jeff Frost <jeff@frostconsultingllc.com>
Cc: Carol Walter <walterc@indiana.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: vacuum verbose relations reporting
Date: Tue, 26 Aug 2008 19:48:55 -0400
Message-ID: <11312.1219794535@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.LNX.4.64.0808261230460.3638@discord.home.frostconsultingllc.com>
References: <Pine.LNX.4.64.0808261207140.5906@discord.home.frostconsultingllc.com>
<E1DC2F12-02E8-4D82-9821-B9C7D01657D3@indiana.edu>
<Pine.LNX.4.64.0808261230460.3638@discord.home.frostconsultingllc.com>
Jeff Frost <jeff@frostconsultingllc.com> writes:
> No I actually mean that this part:
> Current limits are: 600000 page slots, 10000 relations, using 4587 kB.
> NOTICE: max_fsm_relations(10000) equals the number of relations checked
> HINT: You have at least 10000 relations. Consider increasing the
> Just tells me that I'm equal or greater than max_fsm_relations.
Yeah, because that's all that can be told from the contents of the
shared free space map: it's full, but we have no idea how many other
tables might have been competing for space in it.
> But vacuum verbose does tell me how many page_slots are in use even
> when it's greater than max_fsm_pages, so you know what value to use in
> postgresql.conf for the fsm settings.
Well, no :-(. What that number is is the number of page slots that the
relations that are in the FSM would have liked to have --- we have the
"request" size as well as the "allocated" size for each such relation.
We have no idea how many slots the relations that aren't in FSM might
have liked to have.
This whole design is pretty awful, of course (I can say that because it
was my design :-(). There is work in progress to make the fixed-size
FSM go away entirely in 8.4, which will certainly be a boon to DBAs.
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-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, jeff@frostconsultingllc.com, walterc@indiana.edu
Subject: Re: vacuum verbose relations reporting
In-Reply-To: <11312.1219794535@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