Re: Help me recovering data

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема Re: Help me recovering data
Дата
Msg-id 4213FC0F.9040602@bigfoot.com
обсуждение исходный текст
Ответ на Re: Help me recovering data  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Help me recovering data  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: Re: Help me recovering data
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Help me recovering data