Skip site navigation (1) Skip section navigation (2)

Re: Feature freeze date for 8.1

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Feature freeze date for 8.1
Date: 2005-04-29 04:57:58
Message-ID: m3oebykwmh.fsf@knuth.cbbrowne.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
In the last exciting episode, pgman(at)candle(dot)pha(dot)pa(dot)us (Bruce Momjian) wrote:
> 	o integrated auto-vacuum (Bruce)

If this can kick off a vacuum of a Very Large Table at an unfortunate
time, this can turn out to be a prety painful misfeature.

What I'd _really_ love to see (and alas, it's beyond my ken) is some
parallel to the FSM, namely a "Recently Updated Blocks Map," which
would enable a vacuuming approach that would not go through entire
tables, but which would rather go through only those blocks known to
be recently updated.

There continues to be trouble if you have a table that grows to 50
million rows where there are 100K rows that are being heavily
updated.  In effect, only the 100K rows need facuuming.
-- 
(reverse (concatenate 'string "moc.liamg" "@" "enworbbc"))
http://linuxfinances.info/info/emacs.html
Group Dynamics
"Following Minsky and Schelling, consider a person as a society of
agents. A group is then a larger society of such agents. Understand
groups by examining interactions of coalitions of agents that
cross-cut their grouping into people."
-- Mark Miller

In response to

Responses

pgsql-hackers by date

Next:From: a3a18850Date: 2005-04-29 05:10:18
Subject: Re: Distinct-Sampling (Gibbons paper) for Postgres
Previous:From: Bruce MomjianDate: 2005-04-29 04:35:19
Subject: Re: [HACKERS] Increased company involvement

pgsql-patches by date

Next:From: Neil ConwayDate: 2005-04-29 07:08:51
Subject: pg_restore -F bug
Previous:From: Bruce MomjianDate: 2005-04-29 04:24:19
Subject: Update Borland makefile and improve MSC makefile

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group