On Thu, Jul 27, 2017 at 3:31 AM, Mark Rofail <markm.rof...@gmail.com> wrote:

> 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

How many rows of FK table were referencing the PK table row you're
I wonder how may RI trigger work so fast if it has to do some job besides
index search with no results?
I think we should also vary the number of referencing rows.

Alexander Korotkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

Reply via email to