Re: Delay the variable initialization in get_rel_sync_entry - Mailing list pgsql-hackers

From Amit Langote
Subject Re: Delay the variable initialization in get_rel_sync_entry
Date
Msg-id CA+HiwqH=R8163DAy=75vL4KPD5dEHHfv7BqUKQcaXYNjhJXEPw@mail.gmail.com
Whole thread Raw
In response to Re: Delay the variable initialization in get_rel_sync_entry  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
On Wed, Jan 5, 2022 at 10:31 AM Michael Paquier <michael@paquier.xyz> wrote:
> On Fri, Dec 24, 2021 at 01:27:26PM +0000, houzj.fnst@fujitsu.com wrote:
> > Here is the perf result of pgoutput_change after applying the patch.
> > I didn't notice something else that stand out.
> >
> >         |--2.99%--pgoutput_change
> >             |--1.80%--get_rel_sync_entry
> >                     |--1.56%--hash_search
> >
> > Also attach complete profiles.
>
> Thanks.  I have also done my own set of measurements, and the
> difference is noticeable in the profiles I looked at.  So, applied
> down to 13.

Thanks.  I agree the variables were being defined in the wrong place
before this patch.

-- 
Amit Langote
EDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Refactoring of compression options in pg_basebackup
Next
From: Justin Pryzby
Date:
Subject: Re: Map WAL segment files on PMEM as WAL buffers