Search Postgresql Archives

Re: surprising query optimisation

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: surprising query optimisation
From: Thomas Kellerer <spam_eater@xxxxxxx>
Date: Wed, 5 Dec 2018 12:48:28 +0100
In-reply-to: <CAOuzzgpAYrTTvDi_gzwj=EXaCNLLZ4CnxJe-MHTH0Zp-ZZxYcw@mail.gmail.com>
Newsgroups: gmane.comp.db.postgresql.general
References: <03a0af57-3ebc-5501-10ef-6a639c7c34b8@withers.org> <20181128224950.GS3415@tamriel.snowman.net> <5d7f8d97-32f3-fd88-44cc-948673579a71@withers.org> <CAOuzzgpXKJ440Um1-1uEv_HCXU+BFxD7gN8vQBpH1kKXgB8wiA@mail.gmail.com> <076fec6e-3bb4-3a99-e71f-dc1cec684cb6@withers.org> <CAOuzzgpAYrTTvDi_gzwj=EXaCNLLZ4CnxJe-MHTH0Zp-ZZxYcw@mail.gmail.com>
User-agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666

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?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: surprising query optimisation
  - From: Stephen Frost

References:
- surprising query optimisation
  - From: Chris Withers
- Re: surprising query optimisation
  - From: Stephen Frost
- Re: surprising query optimisation
  - From: Chris Withers
- Re: surprising query optimisation
  - From: Stephen Frost
- Re: surprising query optimisation
  - From: Chris Withers
- Re: surprising query optimisation
  - From: Stephen Frost

Prev by Date: Re: surprising query optimisation
Next by Date: Re: surprising query optimisation
Previous by thread: Re: surprising query optimisation
Next by thread: Re: surprising query optimisation
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]