logoalt Hacker News

bitbasher • last Saturday at 8:42 PM • 2 replies • view on HN

pg_bulkload[1] has saved me so much time cold restoring large (1+ TB) databases. It went from 24-72 hours to an hour or two.

I also recommend pg_repack[2] to squash tables on a live system and reclaim disk space. It has saved me so much space.

1: https://ossc-db.github.io/pg_bulkload/pg_bulkload.html

2: https://github.com/reorg/pg_repack

Replies

higeorge13 • yesterday at 5:47 AM

I checked pg_repack a while ago but some issues are a bit concerning to apply in production. Did you face any issues?

➕ show 1 reply
itsthecourier • last Saturday at 10:25 PM

I'm just checking it now

do you export the data with this and then import it in the other db with it?

or do you work with existing postgres backups?

➕ show 1 reply