Re: [HACKERS] GSoC 2017: Foreign Key Arrays
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
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
Вложения
В списке pgsql-hackers по дате отправления:
Предыдущее
От: Masahiko SawadaДата:
Сообщение: Re: [HACKERS] Refreshing subscription relation state inside atransaction block
Следующее
От: Yugo NagataДата:
Сообщение: [HACKERS] Missing comment for max_logical_replication_workers inpostgresql.conf.sample