Re: Autovacuum and invalid page header

From: Ireneusz Pluta <ipluta(at)wp(dot)pl>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Kevin Grittner <kevin(dot)grittner(at)wicourts(dot)gov>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Autovacuum and invalid page header
Date: 2010-09-03 08:17:54
Message-ID: 4C80AF32.6000608@wp.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Tom Lane pisze:
> Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
>
>> Yeah, maybe we should make it put the failed table at the end of the
>> list, for the next run. This is not simple to implement, if only
>> because autovac workers don't have any way to persist state from one run
>> to the next. But this kind of thing causes enough problems that it's
>> probably worth it.
>>
>
>
>> One thing to keep in mind, though, is that a persistent error in a
>> single table is enough to keep a database's datfrozenxid from advancing,
>> and thus shut down in case the wraparound horizon comes too close. So
>> perhaps what we need is more visibility into autovacuum problems.
>>
>
> +1 for the latter. A recurrent vacuum failure is something that needs
> to be dealt with ASAP, not partially-worked-around.
>
> regards, tom lane
>
I am revisiting invalid page header cases due to my problem explained in
another recent post from me.
I am not tracing development process too closely. But, as I can see the
9.0 is almost out, let me ask here if this problem has been taken care of?

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ireneusz Pluta 2010-09-03 08:42:54 Re: Autovacuum and invalid page header
Previous Message Silvio Brandani 2010-09-03 08:15:45 Re: out of memory error