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