Postgres Pro
Downloads
Home   >   mailing lists

Re: Buffer usage detailed by RelKind in EXPLAIN ANALYZE BUFFERS - Mailing list pgsql-hackers

From Andrey Borodin
Subject Re: Buffer usage detailed by RelKind in EXPLAIN ANALYZE BUFFERS
Date
Msg-id CAAhFRxjgZa=PFieotTABHynKpg5OOM+g8r1SPpv25HidrHTFGA@mail.gmail.com
Whole thread Raw
In response to Re: Buffer usage detailed by RelKind in EXPLAIN ANALYZE BUFFERS  (Andres Freund <andres@anarazel.de>)
Responses Re: Buffer usage detailed by RelKind in EXPLAIN ANALYZE BUFFERS
List pgsql-hackers
Tree view 
On Mon, Feb 13, 2023 at 4:39 PM Andres Freund <andres@anarazel.de> wrote:
>
> The problem I'm talking about is the increased overhead in InstrStopNode(),
> due to BufferUsageAccumDiff() getting more expensive.
>

Thanks, now I understand the problem better. According to godbolt.com
my patch doubles the number of instructions in this function. Unless
we compute only tables\indexes\matviews.
Anyway, without regarding functionality of this particular patch,
BufferUsageAccumDiff() does not seem slow to me. It's just a
branchless bunch of simd instructions. Performance of this function
might matter only when called gazillion times per second.


Best regards, Andrey Borodin.
Attachment

pgsql-hackers by date:

Previous
From: Andy Fan
Date:
Subject: Re: A new strategy for pull-up correlated ANY_SUBLINK
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: Time delayed LR (WAS Re: logical replication restrictions)