Re: Help me recovering data

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Help me recovering data
Следующее
От: Agent M
Дата:
Сообщение: Re: UTF8 or Unicode