Read-only tables to avoid row visibility check

From: Seamus Abshere <seamus(at)abshere(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Read-only tables to avoid row visibility check
Date: 2016-02-22 20:35:58
Message-ID: 1456173358.1050061.528652954.75D80819@webmail.messagingengine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,

https://wiki.postgresql.org/wiki/ReadOnlyTables mentions the possibility
of `ALTER TABLE table SET READ ONLY`.

Would this mean that row visibility checks could be skipped and thus
index-only scans much more common?

Thanks,
Seamus

--
Seamus Abshere, SCEA
+598 99 54 99 54
https://github.com/seamusabshere

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Mair 2016-02-22 20:39:31 Re: decoding BLOB's
Previous Message John R Pierce 2016-02-22 19:37:39 Re: decoding BLOB's