Re: Do table-level CHECK constraints affect the query optimizer?

Поиск
Список
Период
Сортировка
Искать
От
Mark Dilger
Тема
Re: Do table-level CHECK constraints affect the query optimizer?
Дата
Msg-id
F92A30BC-AE62-4130-A281-C3844EDEB49F@enterprisedb.com
Ответ на
Список
Дерево обсуждения
Do table-level CHECK constraints affect the query optimizer? Ron <ronljohnsonjr@gmail.com>
Re: Do table-level CHECK constraints affect the query optimizer? Michael Lewis <mlewis@entrata.com>
Re: Do table-level CHECK constraints affect the query optimizer? Ron <ronljohnsonjr@gmail.com>
Re: Do table-level CHECK constraints affect the query optimizer? Tom Lane <tgl@sss.pgh.pa.us>
Re: Do table-level CHECK constraints affect the query optimizer? Ron <ronljohnsonjr@gmail.com>
Re: Do table-level CHECK constraints affect the query optimizer? Tom Lane <tgl@sss.pgh.pa.us>
Re: Do table-level CHECK constraints affect the query optimizer? Ron <ronljohnsonjr@gmail.com>
Re: Do table-level CHECK constraints affect the query optimizer? Mark Dilger <mark.dilger@enterprisedb.com>
Re: Do table-level CHECK constraints affect the query optimizer? Mark Dilger <mark.dilger@enterprisedb.com>
Re: Do table-level CHECK constraints affect the query optimizer? Michael Lewis <mlewis@entrata.com>


> On Jun 29, 2021, at 11:02 AM, Ron  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 по дате отправления
От: Ron
Дата:
От: Adrian Klaver
Дата:
FAQ