From: Jim Nasby <jnasby@pervasive.com>
To: Jeff Frost <jeff@frostconsultingllc.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: strange fsm issues
Date: Thu, 22 Jun 2006 21:24:15 -0500
Message-ID: <D9E39C0B-1D32-4BA6-AEAE-1E2D42ABD3F1@pervasive.com> (raw)
In-Reply-To: <Pine.LNX.4.64.0606220750310.4350@discord.home.frostconsultingllc.com>
References: <Pine.LNX.4.64.0606210915370.27250@glacier.frostconsultingllc.com>
<Pine.LNX.4.64.0606211425580.27250@glacier.frostconsultingllc.com>
<Pine.LNX.4.64.0606220750310.4350@discord.home.frostconsultingllc.com>
On Jun 22, 2006, at 9:52 AM, Jeff Frost wrote:
> So, I set it to 3366499. I came up with this number by:
> select sum(relpages) from pg_class where relkind in ('r','t');
> and adding that up for all the DBs (there is just the one plus
> postgres and template1 and now I get th efollowing, so it appears
> this was actually a good settings.
>
> CPU 0.00s/0.00u sec elapsed 0.00 sec.
> INFO: free space map contains 3339998 pages in 125 relations
> DETAIL: A total of 3341600 page slots are in use (including
> overhead).
> 3341600 page slots are required to track all free space.
> Current limits are: 3366499 page slots, 2000 relations, using
> 19853 KB.
>
> So then the question is..why was vacuum suggesting such low
> settings previously?
Take a look at the source, but I think the issue is that it stops
trying to keep track after some point.
In any case, for this database I doubt it matters, since there's free
space on every page... afaik any update will first try and add the
new tuple on the current page, so as long as you have enough in the
FSM to handle new inserts it won't matter.
Of course, the fact that you have that much free space on every page
makes me think it's not getting vacuumed enough...
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: jnasby@pervasive.com, jeff@frostconsultingllc.com
Subject: Re: strange fsm issues
In-Reply-To: <D9E39C0B-1D32-4BA6-AEAE-1E2D42ABD3F1@pervasive.com>
References: <Pine.LNX.4.64.0606210915370.27250@glacier.frostconsultingllc.com> <Pine.LNX.4.64.0606211425580.27250@glacier.frostconsultingllc.com> <Pine.LNX.4.64.0606220750310.4350@discord.home.frostconsultingllc.com> <D9E39C0B-1D32-4BA6-AEAE-1E2D42ABD3F1@pervasive.com>
* 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