Re: Help me recovering data - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Help me recovering data
Date
Msg-id 25760.1108577338@sss.pgh.pa.us
Whole thread Raw
In response to Re: Help me recovering data  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: Help me recovering data
List pgsql-hackers
Bruno Wolff III <bruno@wolff.to> writes:
> I don't think there is much point in making it configurable. If they knew
> to do that they would most likely know to vacuum as well.

Agreed.

> However, 100K out of 1G seems too small. Just to get wrap around there
> must be a pretty high transaction rate, so 100K may not give much warning.
> 1M or 10M seem to be better.

Good point.  Even 10M is less than 1% of the ID space.  Dunno about you,
but the last couple cars I've owned start flashing warnings when the gas
tank is about 20% full, not 1% full...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Help me recovering data
Next
From: Agent M
Date:
Subject: Re: UTF8 or Unicode