| From: | Shay Rojansky <roji(at)roji(dot)org> |
|---|---|
| To: | Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Andres Freund <andres(at)anarazel(dot)de>, Greg Stark <stark(at)mit(dot)edu>, Tatsuo Ishii <ishii(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: Slowness of extended protocol |
| Date: | 2016-08-02 18:00:58 |
| Message-ID: | CADT4RqBqf3_iRnHuZ=0RhRomEeWm4YvhieP4rQ=Trccgui+TzA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Aug 1, 2016 at 12:12 PM, Vladimir Sitnikov <
sitnikov(dot)vladimir(at)gmail(dot)com> wrote:
> The attached patch passes `make check` and it gains 31221 -> 33547
improvement for "extended pgbench of SELECT 1".
>
> The same version gains 35682 in "simple" mode, and "prepared" mode
achieves 46367 (just in case).
That's great, thanks for looking into it! I hope your patch gets merged.
> Shay, why don't you use a profiler? Seriously.
> I'm afraid "iterate the per-message loop in PostgresMain five times not
once" /"just discussing what may or may not be a problem..." is just
hand-waving.
>
> Come on, it is not that hard.
I really don't get what's problematic with posting a message on a mailing
list about a potential performance issue, to try to get people's reactions,
without diving into profiling right away. I'm not a PostgreSQL developer,
have other urgent things to do and don't even spend most of my programming
time in C.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2016-08-02 18:06:31 | Re: PostmasterContext survives into parallel workers!? |
| Previous Message | Alvaro Herrera | 2016-08-02 17:56:57 | Re: TODO item: Implement Boyer-Moore searching in LIKE queries |