Jon Nelson <jnelson+pgsql(at)jamponi(dot)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