Heikki Linnakangas wrote:
> On 11.11.2011 17:47, Tom Lane wrote:
> > Robert Haas writes:
> >> On Fri, Nov 11, 2011 at 9:59 AM, Tom Lane wrote:
> >>> It occurs to me to wonder how this scenario will interact with the
> >>> recent changes to let VACUUM skip pages. AFAIR there is not a way for a
>
Heikki Linnakangas writes:
> On second thought, if XID wraparound is close enough that the DBA has to
> log in to do manual vacuums to avoid it, relfrozenxid of the
> trouble-making tables are surely older than default
> vacuum_freeze_table_age, so plain VACUUM is enough to scan the whole table
On 11.11.2011 19:15, Heikki Linnakangas wrote:
On 11.11.2011 17:47, Tom Lane wrote:
(3) In disaster
recovery scenarios, the last thing we want is to be imposing extra
conditions on what an already-stressed DBA has to do to fix things;
especially extra conditions that are different from the way i
On 11.11.2011 17:47, Tom Lane wrote:
Robert Haas writes:
On Fri, Nov 11, 2011 at 9:59 AM, Tom Lane wrote:
It occurs to me to wonder how this scenario will interact with the
recent changes to let VACUUM skip pages. AFAIR there is not a way for a
manual VACUUM to set the anti-wraparound mode,
On Nov 11, 2011, at 10:47 AM, Tom Lane wrote:
> Robert Haas writes:
>> On Fri, Nov 11, 2011 at 9:59 AM, Tom Lane wrote:
>>> In another thread, Alvaro quoted from the manual:
>> If for some reason autovacuum fails to clear old XIDs from a table, the
>> system will begin to emit warning
Robert Haas writes:
> On Fri, Nov 11, 2011 at 9:59 AM, Tom Lane wrote:
>> In another thread, Alvaro quoted from the manual:
> If for some reason autovacuum fails to clear old XIDs from a table, the
> system will begin to emit warning messages like this when the
> database's oldest
>
Excerpts from Robert Haas's message of vie nov 11 12:29:42 -0300 2011:
> On Fri, Nov 11, 2011 at 9:59 AM, Tom Lane wrote:
> > In another thread, Alvaro quoted from the manual:
> >> If for some reason autovacuum fails to clear old XIDs from a table,
> >> the
> >> system will begin to
On Fri, Nov 11, 2011 at 9:59 AM, Tom Lane wrote:
> In another thread, Alvaro quoted from the manual:
>> If for some reason autovacuum fails to clear old XIDs from a table, the
>> system will begin to emit warning messages like this when the
>> database's oldest
>> XIDs reach ten
In another thread, Alvaro quoted from the manual:
> If for some reason autovacuum fails to clear old XIDs from a table, the
> system will begin to emit warning messages like this when the
> database's oldest
> XIDs reach ten million transactions from the wraparound point:
>
