Re: Fastpath while arranging the changes in LSN order in logical decoding

Dilip Kumar <dilipbalaut@gmail.com>

From: Dilip Kumar <dilipbalaut@gmail.com>
To: Heikki Linnakangas <hlinnaka@iki.fi>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2020-01-08T12:36:52Z
Lists: pgsql-hackers
On Wed, 8 Jan 2020 at 5:28 PM, Heikki Linnakangas <hlinnaka@iki.fi> wrote:

> On 25/11/2019 05:52, Dilip Kumar wrote:
> > In logical decoding, while sending the changes to the output plugin we
> > need to arrange them in the LSN order.  But, if there is only one
> > transaction which is a very common case then we can avoid building the
> > binary heap.  A small patch is attached for the same.
>
> Does this make any measurable performance difference? Building a
> one-element binary heap seems pretty cheap.


I haven’t really measured the performance for this.  I will try to do that
next week.  Thanks for looking into this.

>
> --
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com

Commits

  1. logical decoding: Remove TODO about unnecessary optimization.

  2. Stamp 12.2.