Robert Haas <robertmh...@gmail.com> writes: > Sure, but I don't want the application to have to know about that, and > I don't really think the driver should need to know about that either. > Your point, as I understand it, is that sufficiently good query > caching in the driver can ameliorate the problem, and I agree with > that.
I don't, actually. If a particular application has a query mix that gets a good win from caching query plans, it should already be using prepared statements. The fact that that's not a particularly popular thing to do isn't simply because people are lazy, it's because they've found out that it isn't worth the trouble for them. Putting query caching logic into drivers isn't going to improve performance for such cases, and it could very possibly make things worse. The driver is the place with the absolute least leverage for implementing caching; it has no visibility into either the application or the server. regards, tom lane -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers