From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-performance@postgresql.org
Subject: Re: Autovacuum / full vacuum
Date: Tue, 17 Jan 2006 09:04:06 -0500
Message-ID: <m3zmlvq7c9.fsf@mobile.int.cbbrowne.com> (raw)
References: <dqigaf$1b98$1@news.hub.org>
<43CCC711.504@familyhealth.com.au>
<dqih4p$1clg$1@news.hub.org>
> did you read my post? In the first part I explained why I don't want
> to increase the FSM that much.
No, you didn't. You explained *that* you thought you didn't want to
increase the FSM. You didn't explain why.
FSM expansion comes fairly cheap, and tends to be an effective way of
eliminating the need for VACUUM FULL. That is generally considered to
be a good tradeoff. In future versions, there is likely to be more of
this sort of thing; for instance, on the ToDo list is a "Vacuum Space
Map" that would collect page IDs that need vacuuming so that
PostgreSQL could do "quicker" vacuums...
--
output = reverse("moc.liamg" "@" "enworbbc")
http://cbbrowne.com/info/internet.html
Given recent events in Florida, the tourism board in Texas has
developed a new advertising campaign based on the slogan "Ya'll come
to Texas, where we ain't shot a tourist in a car since November 1963."
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: cbbrowne@acm.org
Subject: Re: Autovacuum / full vacuum
In-Reply-To: <m3zmlvq7c9.fsf@mobile.int.cbbrowne.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