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

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Do table-level CHECK constraints affect the query optimizer?
Date: 2021-06-29 15:41:00
Message-ID: CAHOFxGpN2_Jfe9Ah1WqLgEGMtOkjqzDp+bb_SVm2O28rojZJQA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2021-06-29 16:13:03 Re: Do table-level CHECK constraints affect the query optimizer?
Previous Message Ron 2021-06-29 15:10:21 Do table-level CHECK constraints affect the query optimizer?