| From: | Mark Rofail <markm(dot)rofail(at)gmail(dot)com> |
|---|---|
| To: | Erik Rijkers <er(at)xs4all(dot)nl> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Alexander Korotkov <aekorotkov(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org, David Steele <david(at)pgmasters(dot)net>, Stephen Frost <sfrost(at)snowman(dot)net>, pgsql-hackers-owner(at)postgresql(dot)org |
| Subject: | Re: GSoC 2017: Foreign Key Arrays |
| Date: | 2017-07-27 00:31:41 |
| Message-ID: | CAJvoCuv6ufngfZBPNq4icCy=x6NpqVVyyPaio97ZHcZVvAC+Zg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I have written some benchmark test.
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
| Attachment | Content-Type | Size |
|---|---|---|
| FK Benchmark.jpg | image/jpeg | 404.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yugo Nagata | 2017-07-27 01:14:35 | Missing comment for max_logical_replication_workers in postgresql.conf.sample |
| Previous Message | Masahiko Sawada | 2017-07-27 00:31:12 | Re: Refreshing subscription relation state inside a transaction block |
