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
|
Список | 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 по дате отправления: