Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1damNk-0006m9-Az for pgsql-hackers@arkaria.postgresql.org; Thu, 27 Jul 2017 17:15:28 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1damNj-0006e3-S6 for pgsql-hackers@arkaria.postgresql.org; Thu, 27 Jul 2017 17:15:27 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1damNi-0006cJ-Pt; Thu, 27 Jul 2017 17:15:26 +0000 Received: from lb1-smtp-cloud7.xs4all.net ([194.109.24.24]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1damNf-0007jI-1N; Thu, 27 Jul 2017 17:15:26 +0000 Received: from webmailclassic.xs4all.nl ([IPv6:2001:888:0:22:194:109:20:203]) by smtp-cloud7.xs4all.net with ESMTPA id amNcdjdPJuWRwamNcdJcju; Thu, 27 Jul 2017 19:15:20 +0200 Received: from gateway-1-21.erasmusmc.nl ([156.83.1.21]) by webmailclassic.xs4all.nl with HTTP (HTTP/1.1 POST); Thu, 27 Jul 2017 19:15:19 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit Date: Thu, 27 Jul 2017 19:15:19 +0200 From: Erik Rijkers To: Mark Rofail Cc: Robert Haas , Alexander Korotkov , Alvaro Herrera , pgsql-hackers@postgresql.org, David Steele , Stephen Frost , pgsql-hackers-owner@postgresql.org Subject: Re: GSoC 2017: Foreign Key Arrays In-Reply-To: References: <20170719200857.zwuyj7wlta6dvzto@alvherre.pgsql> <594424471b555047592783f31142b872@xs4all.nl> Message-ID: X-Sender: er@xs4all.nl User-Agent: XS4ALL Webmail X-CMAE-Envelope: MS4wfE7gRO6E2nSEh741uKHNYbh9nx8/d8LZL/zL1p8Y3arhOymaegZNcollD0F81n5VzsekMq3Y/CAy8f3VZgAmPvpqPsb5eJpiaSG2o1p6lYZfF9PDK6Fd DbIQe1cKfj4gIZQQb1U+hxh9aQ6frv2s2Vf6r/qqwJcNGUrghG0dyrmO4P8jpansyVfLmdf8BGhFRfLCyREqA8SXg5ypEEK9x4cafMdwpafm05EDzUrS+7DJ +/YOtOsvUh1MU5EVx4Z7SRlCzwhZ9GlpjW4Y//33CSpowxlv/MGNM+/B6F2XAdhrzw5fHsNpGJKU7TuaLZC72Gqsesgk3zsVAYpJ3oGu1qA656iEVvG9jPdL zdSn5YiIWlYUBlnHdLTHB+AEHmB1ytcbXYBdP8c7jzxKSeKnNpSAso4ItRLVr7UMSAToJY5WdLFfKNF36UYs5yMxNc/v5Nik0l6JktKbu7kU+CiAbWxTyU1m 1MJ9IczF7kliT4ddd00ALdrxgAhFdiBGd884YAO0u6YNq7q+EhWH+P0oLUIqT0kF95QiGckuJt6MM0HjJrGmmTWr33YynAKifcAPMk86wVMJvpbEGVUH6VYa hSs= List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 2017-07-27 02:31, Mark Rofail wrote: > I have written some benchmark test. > It would help (me at least) if you could be more explicit about what exactly each instance is. Apparently there is an 'original patch': is this the original patch by Marco Nenciarini? Or is it something you posted earlier? I guess it could be distilled from the earlier posts but when I looked those over yesterday evening I still didn't get it. A link to the post where the 'original patch' is would be ideal... thanks! Erik Rijkers > With two tables a PK table with 5 rows and an FK table with growing row > count. > > Once triggering an RI check > at 10 rows, > 100 rows, > 1,000 rows, > 10,000 rows, > 100,000 rows and > 1,000,000 rows > > Please find the graph with the findings attached below > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers