As other commenter mentioned, you can use pg_repack. We also had similar issue a... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		reactor on Sept 16, 2023 \| parent \| context \| favorite \| on: PostgreSQL 16 As other commenter mentioned, you can use pg_repack. We also had similar issue and we configured it to run every month and it works flawlessly.

brianwawok on Sept 17, 2023 [–]

Oh interesting. In my case I am on google hosted postgres, so I’ll need to double check it works there:

Consider applying for YC's Winter 2026 batch! Applications are open till Nov 10
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact