Re: Autovacuum / full vacuum

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Autovacuum / full vacuum
Date: 2006-01-17 14:04:06
Message-ID: m3zmlvq7c9.fsf@mobile.int.cbbrowne.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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."

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Riess 2006-01-17 14:05:29 Re: Autovacuum / full vacuum
Previous Message Christopher Browne 2006-01-17 13:59:28 Re: Autovacuum / full vacuum