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 20:45:09 |
Message-ID: | 20150706204509.GD340@alap3.anarazel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On 2015-07-06 19:29:30 +0200, olivier(dot)gosseaume(at)free(dot)fr wrote:
> To be more concise :
> - ONE transaction with 4095 operations -> consumed in 80mS
> - TEN transactions with 4095 operations each (so 40950 operations) -> 380mS (which as you said is very good -less than linear growth-)
> - ONE transaction with 4096 operations -> consumed in 4204mS (ouch ...). I confirm there are only 4096 changes in one transaction
> - TEN transactions with 4095 operations each (so 40950 operations) -> 34998mS, ouch again
Given the third result it's unlikely, but just to make sure: Are you
sure network issues aren't a factor here? 40950 changes are about 3.8MB,
over a slow network that can take a second. Additionally psql will
display all the changes in a pager, which'll not be fast either (but
shouldn't be included in \timing's output).
Greetings,
Andres Freund
From | Date | Subject | |
---|---|---|---|
Next Message | olivier.gosseaume | 2015-07-06 20:56:22 | Re: BUG #13484: Performance problem with logical decoding |
Previous Message | Andres Freund | 2015-07-06 20:41:38 | Re: BUG #13484: Performance problem with logical decoding |