On Sat, Aug 26, 2017 at 4:59 PM, Jeff Janes <jeff.ja...@gmail.com> wrote: > I still get a 2 fold improvement, from 13668 to 27036, when both > transactions are tested with -M prepared. > > I am surprised, I usually haven't seen that much difference for the default > queries between prepared or not, to the point that I got out of the habit of > testing with it. But back when I was testing with and without > systematically, I did notice that it changed a lot depending on hardware and > concurrency. And of course from version to version different bottlenecks > come and go.
I must admit that I had a similar unpleasant surprise at one point -- "-M prepared" seems to matter *a lot* these days. That's the default that I'd change, if any. -- Peter Geoghegan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
