Hi, On 2025-02-01 03:46:33 -0800, Dmitry Koterov wrote: > > It'd be interesting to see what the paths towards > hash_search_with_hash_value > are. > > One of the popular paths is on the screenshot. They are all more or less > the same when recovery_prefetch=on (and when it's off, the replica behaves > worse, more replication lag).
Yea, I was hoping for a profile with recovery_prefetch=off, so we can see what records are causing most of the "slow" lookups. Greetings, Andres Freund