Advertisement
markrofail

old RI query performance results

Sep 13th, 2017
397
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.42 KB | None | 0 0
  1. note: v5 is with SELECT 1 FROM ONLY fktable x WHERE $1 @> fkcol FOR SHARE OF x;
  2. and v5.1 is with SELECT 1 FROM ONLY fktable x WHERE ARRAY[$1] <@ fkcol FOR SHARE OF x;
  3.  
  4.  
  5. +------------------+------------------+---------+
  6. | Delete w/o index |
  7. +------------------+------------------+---------+
  8. | rows in fk table | v5 | V5.1 |
  9. +------------------+------------------+---------+
  10. | 10 | 0.377 | 0.195 |
  11. | 100 | 0.468 | 0.3 |
  12. | 1,000 | 0.784 | 0.948 |
  13. | 10,000 | 5.082 | 5.39 |
  14. | 100,000 | 39.439 | 53.297 |
  15. | 1,000,000 | 387.1042 | 755.755 |
  16. +------------------+------------------+---------+
  17.  
  18. +------------------+--------------+-------+
  19. | | Delete index | |
  20. +------------------+--------------+-------+
  21. | rows in fk table | v5 | V5.1 |
  22. +------------------+--------------+-------+
  23. | 10 | 0.339 | 0.444 |
  24. | 100 | 0.303 | 0.254 |
  25. | 1,000 | 0.917 | 0.721 |
  26. | 10,000 | 4.148 | 5.574 |
  27. | 100,000 | 6.81 | 1.533 |
  28. | 1,000,000 | 14.068 | 7.441 |
  29. +------------------+--------------+-------+
  30.  
  31. +------------------+------------------+---------+
  32. | | Update w/o index | |
  33. +------------------+------------------+---------+
  34. | rows in fk table | v5 | V5.1 |
  35. +------------------+------------------+---------+
  36. | 10 | 0.412 | 0.369 |
  37. | 100 | 0.444 | 0.422 |
  38. | 1,000 | 0.582 | 1.263 |
  39. | 10,000 | 4.428 | 5.631 |
  40. | 100,000 | 40.0351 | 52.747 |
  41. | 1,000,000 | 408.3397 | 544.776 |
  42. +------------------+------------------+---------+
  43.  
  44. +------------------+--------------+-------+
  45. | | Update index | |
  46. +------------------+--------------+-------+
  47. | rows in fk table | v5 | V5.1 |
  48. +------------------+--------------+-------+
  49. | 10 | 0.46 | 0.496 |
  50. | 100 | 0.511 | 0.338 |
  51. | 1,000 | 1.16 | 0.781 |
  52. | 10,000 | 5.279 | 5.703 |
  53. | 100,000 | 5.201 | 1.59 |
  54. | 1,000,000 | 13.493 | 7.638 |
  55. +------------------+--------------+-------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement