From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Mark Rofail <markm.rofail@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Cc: David Steele <david@pgmasters.net>
Cc: Andreas Karlsson <andreas@proxel.se>
Cc: Alexander Korotkov <aekorotkov@gmail.com>
Cc: Erik Rijkers <er@xs4all.nl>
Cc: Hans-Jürgen Schönig <hs@cybertec.at>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Stephen Frost <sfrost@snowman.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: [HACKERS] GSoC 2017: Foreign Key Arrays
Date: Wed, 11 Apr 2018 10:29:59 -0300
Message-ID: <20180411132959.xjfiicra2py2fuz3@alvherre.pgsql> (raw)
In-Reply-To: <CAJvoCutyJSuOp_jdJBqmQ=dGonEX_xN1ZwFpEyzmO4FaPhx0DQ@mail.gmail.com>
Mark Rofail wrote:
> > In particular: it seemed to me that you decided to throw away the idea
> > of the new GIN operator without sufficient evidence that it was
> > unnecessary.
>
> I have to admit to that. But in my defence @> is also GIN indexable so the
> only difference in performance between 'anyarray @>> anyelement' and
> 'anyarray @> ARRAY [anyelement]' is the delay caused by the ARRAY[]
> operation theoretically.
I think I need to review Tom's bounce-for-rework email
https://postgr.es/m/28389.1351094795@sss.pgh.pa.us
to respond to this intelligently. Tom mentioned @> there but there was
a comment about the comparison semantics used by that operator, so I'm
unclear on whether or not that issue has been fixed.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: alvherre@alvh.no-ip.org, markm.rofail@gmail.com, david@pgmasters.net, andreas@proxel.se, aekorotkov@gmail.com, er@xs4all.nl, hs@cybertec.at, robertmhaas@gmail.com, sfrost@snowman.net, tgl@sss.pgh.pa.us
Subject: Re: [HACKERS] GSoC 2017: Foreign Key Arrays
In-Reply-To: <20180411132959.xjfiicra2py2fuz3@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox