Re: [HACKERS] GSoC 2017: Foreign Key Arrays

Поиск
Список
Период
Сортировка
Искать
От
Mark Rofail
Тема
Re: [HACKERS] GSoC 2017: Foreign Key Arrays
Дата
Msg-id
CAJvoCusUmk7iBNf7ak_FdT+b=tot3smRNH9DOjDMUEzNFXgrfg@mail.gmail.com
Ответ на
Список
Дерево обсуждения
[HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alexander Korotkov <aekorotkov@gmail.com>
[HACKERS] regproc and when to schema-qualify Chapman Flack <chap@anastigmatix.net>
Re: [HACKERS] regproc and when to schema-qualify Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Erik Rijkers <er@xs4all.nl>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Erik Rijkers <er@xs4all.nl>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: Re: [HACKERS] GSoC 2017: Foreign Key Arrays David Steele <david@pgmasters.net>
Re: Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays David Steele <david@pgmasters.net>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Zhihong Yu <zyu@yugabyte.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: GSoC 2017: Foreign Key Arrays Joel Jacobson <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays "Joel Jacobson" <joel@compiler.org>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Zhihong Yu <zyu@yugabyte.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Zhihong Yu <zyu@yugabyte.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Erik Rijkers <er@xs4all.nl>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Erik Rijkers <er@xs4all.nl>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Enrique Meneses <emmeneses@gmail.com>
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail <markm.rofail@gmail.com>
To summarise, the options we have to solve the limitation of the @>(anyarray , anyelement) where it produces the following error: operator does not exist: integer[] @> smallint

Option 1: Multiple Operators
Have separate operators for every combination of datatypes instead of a single polymorphic definition (i.e int4[] @>> int8, int4[] @>> int4, int4[] @>> int2, int4[] @>> numeric.)

Drawback: High maintenance.

Option 2: Explicit casting
Where we compare the datatype of the 2 operands and cast with the appropriate datatype

Drawback: figuring out the appropriate cast may require considerable computation

Option 3: Unsafe Polymorphic datatypes
This a little out there. But since @>(anyarray, anyelement) have to resolve to the same datatype. How about defining new datatypes without this constraint? Where we handle the datatypes ourselves? It would ve something like @>(unsafeAnyarray, unsafeAnyelement).

Drawback: a lot of defensive programming has to be implemented to guard against any exception.

Another thing
Until this is settled, another thing I have to go through is performance testing. To provide evidence that all we did actually enhances the performance of the RI checks. How can I go about this? 

Best Regards,
Mark Rofail
В списке pgsql-hackers по дате отправления
От: Mark Rofail
Дата:
От: Neha Sharma
Дата:
FAQ