Re: BUG #13484: Performance problem with logical decoding - Mailing list pgsql-bugs

From Andres Freund
Subject Re: BUG #13484: Performance problem with logical decoding
Date
Msg-id 20150707101453.GF30359@alap3.anarazel.de
Whole thread Raw
In response to Re: BUG #13484: Performance problem with logical decoding  (olivier.gosseaume@free.fr)
Responses Re: BUG #13484: Performance problem with logical decoding  (Andres Freund <andres@anarazel.de>)
List pgsql-bugs
On 2015-07-07 09:55:50 +0200, olivier.gosseaume@free.fr wrote:
> >Great. I will try to rebuild on Windows with this patch and let you know
>
> You got it :)

Phew. Good to know, thanks.

> I rebuilt postgres 9.4.4 x64 this morning with your patch in
> reorderbuffer.c and now it FLIES (140mS for a transaction with 4096
> inserts, 600mS for 40960 inserts).

Sorry for being boring and reiterating: This'll still be faster when
using the streaming interface ;)

> Will this patch be included in 9.4.5 ?

Yes.

> PS: the build process on Windows is very simple and straightforward, congrats.

Good to know. The last time I built PG on windows (2006?) it wasn't ;)

pgsql-bugs by date:

Previous
From: Petr Jelinek
Date:
Subject: Re: BUG #13126: table constraint loses its comment
Next
From: Andres Freund
Date:
Subject: Re: BUG #13484: Performance problem with logical decoding