pgsql: Use SET TRANSACTION READ ONLY in pg_dump, if server supports it.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Use SET TRANSACTION READ ONLY in pg_dump, if server supports it.
Date: 2013-01-19 22:56:49
Message-ID: E1TwhLF-0002bc-3n@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Use SET TRANSACTION READ ONLY in pg_dump, if server supports it.

This currently does little except serve as documentation. (The one case
where it has a performance benefit, SERIALIZABLE mode in 9.1 and up, was
already using READ ONLY mode.) However, it's possible that it might have
performance benefits in future, and in any case it seems like good
practice since it would catch any accidentally non-read-only operations.

Pavan Deolasee

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/26d905a12dda783783c60cec04decb00cd2e67f4

Modified Files
--------------
src/bin/pg_dump/pg_dump.c | 9 ++++++++-
1 files changed, 8 insertions(+), 1 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Magnus Hagander 2013-01-20 15:13:37 pgsql: Clarify that streaming replication can be both async and sync
Previous Message Tom Lane 2013-01-19 22:21:37 pgsql: Modernize string literal syntax in tutorial example.