| From: | Erik Rijkers <er(at)xs4all(dot)nl> |
|---|---|
| To: | Mark Rofail <markm(dot)rofail(at)gmail(dot)com> |
| 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 17:15:19 |
| Message-ID: | effa042f9820ebf56e8f79772495d893@xs4all.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavan Deolasee | 2017-07-27 17:15:51 | Re: Patch: Write Amplification Reduction Method (WARM) |
| Previous Message | Alvaro Herrera | 2017-07-27 17:10:01 | Re: Increase Vacuum ring buffer. |