Home > mailing lists

read only transactions - Mailing list pgsql-performance

From	Jon Nelson
Subject	read only transactions
Date	October 12, 2010 17:25:17
Msg-id	AANLkTikaFMqNPcyAch5t3tL7Sj+HU0eiDaCj_vnFACOz@mail.gmail.com Whole thread Raw
Responses	Re: read only transactions Re: read only transactions
List	pgsql-performance

Are there any performance implications (benefits) to executing queries
in a transaction where
SET TRANSACTION READ ONLY;
has been executed?


--
Jon

From: Tom Lane
Date: 12 October 2010, 17:08:10
Subject: Re: Slow count(*) again...

From: Mladen Gogala
Date: 12 October 2010, 17:36:56
Subject: Re: Slow count(*) again...