Partitioning table in #postgres means smaller table and smaller tables allow faster vacuum which will potentially improve query performance by
- less bloat (due to more up-to-dated xmin)
- fewer heap fetch due to more up-to-dated VisibilityMap
Partitioning table in #postgres means smaller table and smaller tables allow faster vacuum which will potentially improve query performance by
- less bloat (due to more up-to-dated xmin)
- fewer heap fetch due to more up-to-dated VisibilityMap
No replies yet.