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.On Mon, Feb 22, 2016 at 3:35 PM, Seamus Abshere <seamus@abshere.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@postgresql.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.
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
В списке pgsql-general по дате отправления:
Предыдущее
От: Nicklas AvénДата:
Сообщение: ERROR: cannot convert relation containing dropped columns to view