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

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Do table-level CHECK constraints affect the query optimizer?
Дата
Msg-id CAHOFxGqmR-Cfro9gcvgmnx0-qy44TixHUaeF1PKKcAhS0GMvQw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Do table-level CHECK constraints affect the query optimizer?  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-general
Дерево обсуждения
Other than rows being frozen on test (and not on live), I'm not aware of anything that would push the planner to choose to do an index scan on an entire table. Maybe someone else will chime in. Or, if you try running vacuum freeze on live and can verify if that changes the result.

I'm not sure why sampling rate would matter at all if you are reading the entire set of data.

What version?

В списке pgsql-general по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: Do table-level CHECK constraints affect the query optimizer?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Do table-level CHECK constraints affect the query optimizer?