Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Lewis
Subject Re: Do table-level CHECK constraints affect the query optimizer?
Date
Msg-id CAHOFxGpN2_Jfe9Ah1WqLgEGMtOkjqzDp+bb_SVm2O28rojZJQA@mail.gmail.com
Whole thread Raw
In response to Do table-level CHECK constraints affect the query optimizer?  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: Do table-level CHECK constraints affect the query optimizer?  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Ron
Date:
Subject: Do table-level CHECK constraints affect the query optimizer?
Next
From: Ron
Date:
Subject: Re: Do table-level CHECK constraints affect the query optimizer?