News for hackers. Stuff that matters.

A comment on An unexpected find that freed 20GB of unused index space in PostgreSQL. Parent comment

Re:An unexpected find that freed 20GB of unused index space ... by jskrablin on Monday February 01, 2021 @04:46PM (#25994451)
Ever since there's pg_upgrade available. Since 8.4 or so - https://www.percona.com/blog/2019/04/12/fast-upgrade-of-lega...

Dump and reload is ok if you have a small database or can afford hours of downtime... if not, use pg_upgrade.

[ Parent | on HN ]

There are no comments on this comment yet.