Re: [HACKERS] GSoC 2017: Foreign Key Arrays

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