> > Shay Rojansky <r...@roji.org>: > >> I'm well aware of how the extended protocol works, but it seems odd for a >> 30% increase in processing time to be the result exclusively of processing >> 5 messages instead of just 1 - it doesn't seem like that big a deal >> (although I may be mistaken). I was imagining that there's something more >> fundamental in how the protocol or PostgreSQL state is managed internally, >> that would be responsible for the slowdown. >> > > Hi, have you tried to use a profiler to identify the _cause_ of the > difference in performance? > > Here's relevant read: > https://shipilev.net/blog/2015/voltmeter/#_english_version >
I'm definitely not a stage where I'm interested in the cause of the difference. I'm not a PostgreSQL hacker, and I'm not going into the source code to try and optimize anything (not yet anyway). For now, I'm just looking to get a high-level picture of the situation and to inform people that there may be an issue. Or in terms of your article, I'm plugging a light bulb into the wall socket and the light is dim, so I'm trying to ask the building electricity team if they're aware of it, if if it's a fixable situation and if there are plans to fix it - before pushing any fingers into some electricity cabinet I don't know.
