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