News for hackers. Stuff that matters.
Re:Bulk loading into PostgreSQL: Options and comparison by dilatedmind on Sunday December 13, 2020 @12:26PM (#25408193)
The best use case I've had for partitioning tables is when there is a lot of churn that would otherwise result in significant vacuuming. For example, a table holding the past 7 days of data would require deleting 1/7 of its rows every day.

Swapping out a child table and dropping the old one is free in that sense, but does require an exclusive lock which can cause issues if you have long running queries.

There are no comments on this comment yet.