Re: GSoC 2017: Foreign Key Arrays

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 21:08:37
Message-ID: CAJvoCuvxHKm4siJuUcbwU-P6EtwPnGt_MJoaD3MZxhYTXSJsYg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Here is the new Patch with the bug fixes and the New Patch with the Index
in place performance results.

I just want to point this out because I still can't believe the numbers. In
reference to the old patch:
The new patch without the index suffers a 41.68% slow down, while the new
patch with the index has a 95.18% speed up!

Best Regards,
Mark Rofail

Attachment Content-Type Size
elemOperatorV4.patch text/x-patch 21.3 KB
modified_with_index_results.out application/octet-stream 643.1 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Erik Rijkers 2017-07-24 21:25:24 Re: GSoC 2017: Foreign Key Arrays
Previous Message Mark Rofail 2017-07-24 20:51:21 Re: GSoC 2017: Foreign Key Arrays