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

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Do table-level CHECK constraints affect the query optimizer?
Дата
Msg-id CAHOFxGpN2_Jfe9Ah1WqLgEGMtOkjqzDp+bb_SVm2O28rojZJQA@mail.gmail.com
обсуждение исходный текст
Ответ на Do table-level CHECK constraints affect the query optimizer?  (Ron <ronljohnsonjr@gmail.com>)
Ответы Re: Do table-level CHECK constraints affect the query optimizer?
Список pgsql-general
Are vacuum and analyze happening regularly on the live system? What's an example query that uses indexes on test and does not on live? Does the live system show poor estimates when executing 'explain analyze select...' and the test system show semi-accurate row estimates?

50 million seems to be a fairly low row count to be partitioned. What version is this on?

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

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