Re: Help me recovering data

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Help me recovering data
Date: 2005-02-17 02:06:07
Message-ID: 4213FC0F.9040602@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> Bruno Wolff III <bruno(at)wolff(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-02-17 04:36:45 Re: Help me recovering data
Previous Message Gaetano Mendola 2005-02-17 01:58:53 Re: Help me recovering data