Re: Patch proposal - parameter to limit amount of FPW because of hint bits per second - Mailing list pgsql-hackers

From Michail Nikolaev
Subject Re: Patch proposal - parameter to limit amount of FPW because of hint bits per second
Date
Msg-id CANtu0oijDRJQ+UiMfEYgm_ua4U14yts+8CXBdPZQsNZbyM6jxw@mail.gmail.com
Whole thread Raw
In response to Re: Patch proposal - parameter to limit amount of FPW because of hint bits per second  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: Patch proposal - parameter to limit amount of FPW because of hint bits per second  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-hackers
Hello, Peter.

> * Instead of avoiding the FPI when this happens, proactively call
> _bt_simpledel_pass() just before _bt_killitems() returns. Accept the
> immediate cost of setting an LP_DEAD bit, just like today, but avoid
> repeated FPIs.

Hm, not sure here
AFAIK current implementation does not produce repeated FPIs. Page is
marked as dirty on the first bit. So, others LP_DEAD (if not set by
single scan) do not generate FPI until checkpoint is ready.
Also, the issue affects GITS and HASH indexes and HEAP pages.

Best regards,
Michail.



pgsql-hackers by date:

Previous
From: Jian Guo
Date:
Subject: Re: Summary Sort workers Stats in EXPLAIN ANALYZE
Next
From: Dilip Kumar
Date:
Subject: Re: Support logical replication of DDLs