Re: new autovacuum criterion for visible pages

Поиск
Список
Период
Сортировка
От Vik Fearing
Тема Re: new autovacuum criterion for visible pages
Дата
Msg-id 3192988a-f48a-08e5-1f68-774d160934d1@2ndquadrant.fr
обсуждение исходный текст
Ответ на Re: new autovacuum criterion for visible pages  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-hackers
On 12/08/16 15:15, Peter Eisentraut wrote:
> On 8/11/16 11:59 AM, Jeff Janes wrote:
>> Insertions and HOT-updates clear vm bits but don't increment the
>> counters that those existing parameters are compared to.
>>
>> Also, the relationship between number of updated/deleted rows and the
>> number of hint-bits cleared can be hard to predict due to possible
>> clustering of the updates into the same blocks.  So it would be hard
>> to know what to set the values to.
> 
> Well, the current threshold formulas aren't an exact science either.
> They just trigger autovacuum often enough relative to table size and
> activity.  Just fudging in the insert and HOT update counters times some
> factor might be enough, and it would get this functionality out to all
> users without more effort.

I have a patch I wrote a while ago that does this.  I haven't submitted
it yet because the documentation is lacking.  I will post it over the
weekend (I had planned to do it before the commitfest anyway).
-- 
Vik Fearing                                          +33 6 46 75 15 36
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support



В списке pgsql-hackers по дате отправления:

Предыдущее
От: amul sul
Дата:
Сообщение: Server crash due to SIGBUS(Bus Error) when trying to access the memory created using dsm_create().
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Add hint for function named "is"