Re: Read-only tables to avoid row visibility check

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(at)abshere(dot)net> 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(at)postgresql(dot)org)
> 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.