Jon Nelson <jnelson+pg...@jamponi.net> wrote: > Are there any performance implications (benefits) to executing > queries in a transaction where > SET TRANSACTION READ ONLY; > has been executed? I don't think it allows much optimization in any current release. It wouldn't be a bad idea to use it where appropriate, though, as future releases might do something with it. If you include this on the BEGIN statement, that will save a round trip. -Kevin
-- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
