Postgres Pro
Downloads
Home   >   mailing lists

Re: surprising query optimisation - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: surprising query optimisation
Date
Msg-id 4b68075c-55b0-e937-f794-125251573011@gmx.net
Whole thread Raw
In response to Re: surprising query optimisation  (Stephen Frost <sfrost@snowman.net>)
Responses Re: surprising query optimisation  (Stephen Frost <sfrost@snowman.net>)
List pgsql-general
Tree view 
Stephen Frost schrieb am 30.11.2018 um 14:05:
> PG doesn’t know, with complete certainty, that there’s only 3
> values.
 
Would the optimizer consult a check constraint ensuring that?

pgsql-general by date:

Previous
From: Chris Withers
Date:
Subject: Re: surprising query optimisation
Next
From: Thomas Kellerer
Date:
Subject: Re: surprising query optimisation