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 CAHOFxGqmR-Cfro9gcvgmnx0-qy44TixHUaeF1PKKcAhS0GMvQw@mail.gmail.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
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 by date:

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