Re: BUG #13484: Performance problem with logical decoding

From: Andres Freund <andres(at)anarazel(dot)de>
To: olivier(dot)gosseaume(at)free(dot)fr
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #13484: Performance problem with logical decoding
Date: 2015-07-06 21:21:26
Message-ID: 20150706212126.GF340@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 2015-07-06 23:05:27 +0200, Andres Freund wrote:
> Ugh, I have a theory. I guess you can't easily recompile postgres with a
> patch and test again? I don't have access to windows...

So the problem I'm seing is that there's a typo/bug in
ReorderBufferSerializeTXN(). It closes the filehandle after each
individual spilled file instead of keeping it open for up to 16MB of
WAL. On linux that doesn't hurt particularly much, the file isn't
flushed to disk. Which presumably is why we haven't noticed. But if
windows does that differently...

Greetings,

Andres Freund

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2015-07-06 21:23:32 Re: BUG #13484: Performance problem with logical decoding
Previous Message Andres Freund 2015-07-06 21:05:27 Re: BUG #13484: Performance problem with logical decoding