On Mon, Feb 22, 2016 at 2: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? Personally I don't see how that buys you very much. Right now you can VACUUM the table which will update the visibility map, allowing index only scans to be chosen. Visibility checks are also already optimized away by the database over time via hint bits. I think the optimization you are looking for is to have the database exploit the fact that when the table is created and/or loaded in a single transaction, it marks everything visible and valid by default and then wipes it all away should the insert fail. merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
