Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- note: v5 is with SELECT 1 FROM ONLY fktable x WHERE $1 @> fkcol FOR SHARE OF x;
- and v5.1 is with SELECT 1 FROM ONLY fktable x WHERE ARRAY[$1] <@ fkcol FOR SHARE OF x;
- +------------------+------------------+---------+
- | Delete w/o index |
- +------------------+------------------+---------+
- | rows in fk table | v5 | V5.1 |
- +------------------+------------------+---------+
- | 10 | 0.377 | 0.195 |
- | 100 | 0.468 | 0.3 |
- | 1,000 | 0.784 | 0.948 |
- | 10,000 | 5.082 | 5.39 |
- | 100,000 | 39.439 | 53.297 |
- | 1,000,000 | 387.1042 | 755.755 |
- +------------------+------------------+---------+
- +------------------+--------------+-------+
- | | Delete index | |
- +------------------+--------------+-------+
- | rows in fk table | v5 | V5.1 |
- +------------------+--------------+-------+
- | 10 | 0.339 | 0.444 |
- | 100 | 0.303 | 0.254 |
- | 1,000 | 0.917 | 0.721 |
- | 10,000 | 4.148 | 5.574 |
- | 100,000 | 6.81 | 1.533 |
- | 1,000,000 | 14.068 | 7.441 |
- +------------------+--------------+-------+
- +------------------+------------------+---------+
- | | Update w/o index | |
- +------------------+------------------+---------+
- | rows in fk table | v5 | V5.1 |
- +------------------+------------------+---------+
- | 10 | 0.412 | 0.369 |
- | 100 | 0.444 | 0.422 |
- | 1,000 | 0.582 | 1.263 |
- | 10,000 | 4.428 | 5.631 |
- | 100,000 | 40.0351 | 52.747 |
- | 1,000,000 | 408.3397 | 544.776 |
- +------------------+------------------+---------+
- +------------------+--------------+-------+
- | | Update index | |
- +------------------+--------------+-------+
- | rows in fk table | v5 | V5.1 |
- +------------------+--------------+-------+
- | 10 | 0.46 | 0.496 |
- | 100 | 0.511 | 0.338 |
- | 1,000 | 1.16 | 0.781 |
- | 10,000 | 5.279 | 5.703 |
- | 100,000 | 5.201 | 1.59 |
- | 1,000,000 | 13.493 | 7.638 |
- +------------------+--------------+-------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement