Re: Slowness of extended protocol - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Slowness of extended protocol
Date
Msg-id 20160810160620.GI4028@tamriel.snowman.net
Whole thread Raw
In response to Re: Slowness of extended protocol  (Vladimir Sitnikov <sitnikov.vladimir@gmail.com>)
Responses Re: Slowness of extended protocol  (Vladimir Sitnikov <sitnikov.vladimir@gmail.com>)
List pgsql-hackers
* Vladimir Sitnikov (sitnikov.vladimir@gmail.com) wrote:
> It works completely transparent to the application, and it does use
> server-prepared statements even though application builds "brand new" sql
> text every time.

And is the source of frequent complaints on various mailing lists along
the lines of "why did my query suddently get slow the 6th time it was
run?!".

I encourage you to look through the archives and read up on how and why
that can happen.

Thanks!

Stephen

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Proposal for CSN based snapshots
Next
From: Tom Lane
Date:
Subject: Re: Is there a way around function search_path killing SQL function inlining?