agora inbox for pgsql-hackers@postgresql.org
help / color / mirror / Atom feedFrom: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: Gregory Stark <stark@enterprisedb.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: Visibility map, partial vacuums
Date: Thu, 15 Jan 2009 17:57:09 +0200
Message-ID: <496F5CD5.3010300@enterprisedb.com> (raw)
In-Reply-To: <200901151548.n0FFmr204820@momjian.us>
References: <200901151548.n0FFmr204820@momjian.us>
Bruce Momjian wrote:
> Heikki Linnakangas wrote:
>>>> Also, is anything being done about the concern about 'vacuum storm'
>>>> explained below?
>>> I'm interested too.
>> The additional "vacuum_freeze_table_age" (as I'm now calling it) setting
>> I discussed in a later thread should alleviate that somewhat. When a
>> table is autovacuumed, the whole table is scanned to freeze tuples if
>> it's older than vacuum_freeze_table_age, and relfrozenxid is advanced.
>> When different tables reach the autovacuum threshold at different times,
>> they will also have their relfrozenxids set to different values. And in
>> fact no anti-wraparound vacuum is needed.
>>
>> That doesn't help with read-only or insert-only tables, but that's not a
>> new problem.
>
> OK, is this targeted for 8.4?
Yes. It's been on my todo list for a long time, and I've also added it
to the Open Items list so that we don't lose track of it.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
view thread (54+ messages) latest in thread
reply
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-hackers@postgresql.org
Cc: heikki.linnakangas@enterprisedb.com, bruce@momjian.us, stark@enterprisedb.com, tgl@sss.pgh.pa.us
Subject: Re: Visibility map, partial vacuums
In-Reply-To: <496F5CD5.3010300@enterprisedb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox