Re: hash_search_with_hash_value is high in "perf top" on a replica - Mailing list pgsql-hackers

From Andres Freund
Subject Re: hash_search_with_hash_value is high in "perf top" on a replica
Date
Msg-id 2oapols65vuwgp43bu5ikgb3om4jrh24dcs5wz2uo3qrugyvyh@bt2vho43nncq
Whole thread Raw
In response to hash_search_with_hash_value is high in "perf top" on a replica  (Dmitry Koterov <dmitry.koterov@gmail.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: jian he
Date:
Subject: Re: NOT ENFORCED constraint feature
Next
From: Andres Freund
Date:
Subject: Re: hash_search_with_hash_value is high in "perf top" on a replica