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

From Gaetano Mendola
Subject Re: Help me recovering data
Date
Msg-id 4213FC0F.9040602@bigfoot.com
Whole thread Raw
In response to Re: Help me recovering data  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Help me recovering data  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> 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...

BTW, why not do an automatic vacuum instead of shutdown ? At least the
DB do not stop working untill someone study what the problem is and
how solve it.


Regards
Gaetano Mendola



pgsql-hackers by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: Help me recovering data
Next
From: Tom Lane
Date:
Subject: Re: Help me recovering data