| From: | Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com> |
|---|---|
| To: | Shay Rojansky <roji(at)roji(dot)org>, Tatsuo Ishii <ishii(at)postgresql(dot)org> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Slowness of extended protocol |
| Date: | 2016-07-31 15:47:25 |
| Message-ID: | CAB=Je-HMRjFKapEhom6aySXwGr-tJqRScWTKb7cC+mdfvyaKng@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Shay Rojansky <roji(at)roji(dot)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
Vladimir
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2016-07-31 15:53:00 | Re: Syntax of xmltable function |
| Previous Message | Shay Rojansky | 2016-07-31 15:05:28 | Re: Slowness of extended protocol |