Re: Selectivity estimation for intarray with @@

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>, Uriy Zhuravlev <u(dot)zhuravlev(at)postgrespro(dot)ru>
Cc: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Selectivity estimation for intarray with @@
Date: 2015-07-21 14:14:39
Message-ID: 55AE53CF.1050904@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Some notices about code:

1 Near function transformOperator() there is wrong operator name "@<"
2 int_query (and intquery) should be replaced to query_int to be consistent with
actual type name. At least where it's used as separate lexeme.
3 For historical reasons @@ doesn't commutate with itself, it has a commutator
~~. Patch assumes that @@ is self-commutator, but ~~ will use 'contsel' as a
restrict estimation. Suppose, we need to declare ~~ as deprecated and introduce
commutating @@ operator.

--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Petr Jelinek 2015-07-21 14:14:46 Re: creating extension including dependencies
Previous Message Tom Lane 2015-07-21 14:00:56 Re: "make check" changes have caused buildfarm deterioration.