Jon Nelson <jnelson+pgsql@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
