Postgres Pro
Downloads
Home   >   mailing lists

Re: Do table-level CHECK constraints affect the query optimizer? - Mailing list pgsql-general

From Mark Dilger
Subject Re: Do table-level CHECK constraints affect the query optimizer?
Date
Msg-id F92A30BC-AE62-4130-A281-C3844EDEB49F@enterprisedb.com
Whole thread Raw
In response to Re: Do table-level CHECK constraints affect the query optimizer?  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Tree view 

> On Jun 29, 2021, at 11:02 AM, Ron <ronljohnsonjr@gmail.com> wrote:
>
> What's an IOS?

An Index Only Scan.  See https://www.postgresql.org/docs/14/indexes-index-only-scans.html
—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Do table-level CHECK constraints affect the query optimizer?
Next
From: Adrian Klaver
Date:
Subject: Re: Overlapping timestamptz ranges with priority