| From: | Mark Rofail <markm(dot)rofail(at)gmail(dot)com> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Alexander Korotkov <aekorotkov(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, David Steele <david(at)pgmasters(dot)net>, Stephen Frost <sfrost(at)snowman(dot)net> |
| Subject: | Re: GSoC 2017: Foreign Key Arrays |
| Date: | 2017-07-24 20:51:21 |
| Message-ID: | CAJvoCusJAnDV1bTFWf97SggkEmMtzRne4OVao3fY6pz24gSZrw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
>
> However, there is a bug that prevented me from testing the third scenario,
> I assume there's an issue of incompatible types problem since the right
> operand type is anyelement and the supporting procedures expect anyarray.
> I am working on debugging it right now.
>
I have also solved the bug that prevented me from performance testing the
New Patch with the Index in place.
Here is a summary of the results:
A- Original Patch
DELETE Average Execution time = 3.508 ms
UPDATE Average Execution time = 3.239 ms
B- New Patch
DELETE Average Execution time = 4.970 ms
UPDATE Average Execution time = 4.170 ms
C- With Index
DELETE Average Execution time = 0.169 ms
UPDATE Average Execution time = 0.147 ms
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Rofail | 2017-07-24 21:08:37 | Re: GSoC 2017: Foreign Key Arrays |
| Previous Message | Mark Rofail | 2017-07-24 20:50:11 | Re: GSoC 2017: Foreign Key Arrays |