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

Reply to this note

Please Login to reply.

Discussion

No replies yet.