News for hackers. Stuff that matters.
Re:PostgreSQL 16 Released by ellisv on Thursday September 14, 2023 @01:12PM (#37511742)
If rewriting the table is part of a regular workflow, then database configuration can play a significant role in its performance. However I still contend that rewriting tables regularly is an anti pattern.

Are you able to partition any of your tables so that you can VACUUM FULL the partitions individually?

Re:PostgreSQL 16 Released by brianwawok on Sunday September 17, 2023 @04:00PM (#37548775)
Yah partition is my eventual end goal. It’s getting less and less awkward with each PG version to partition. It’s still a little awkward in Django. But heck, I haven’t tried it in a year, maybe worth another shot.