Re: Read-only tables to avoid row visibility check

[Melvin Davidson <melvin6925@xxxxxxxxx>]

First of all, it would be really nice if you mentioned the version of PostgreSQL and O/S when posing questions.

That being said, that wiki is a _discussion_, and as such, a suggestion on how it "might" be implemented.

However, at this time, there is no such option as SET READ ONLY in any version of PostgreSQL.

The best you can do is revoke INSERT, UPDATE & DELETE from public and all specific granted users.

On Mon, Feb 22, 2016 at 3:35 PM, Seamus Abshere <seamus@xxxxxxxxxxx> wrote:

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


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--

Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.