Re: Read-only tables to avoid row visibility check

From: Seamus Abshere <seamus(at)abshere(dot)net>
To: Melvin Davidson <melvin6925(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Read-only tables to avoid row visibility check
Date: 2016-02-22 21:38:03
Message-ID: 1456177083.1063785.528715434.66BF3C40@webmail.messagingengine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Feb 22, 2016, at 06:30 PM, Melvin Davidson wrote:
> However, at this time, there is no such option as SET READ ONLY in any version of PostgreSQL.

I know.

I am wondering if hypothetical read-only tables would make index-only
scans more possible by avoiding the need for row visibility checks.

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Wiencek 2016-02-22 21:43:19 synch streaming replication question
Previous Message Melvin Davidson 2016-02-22 21:30:57 Re: Read-only tables to avoid row visibility check