An unexpected find that freed 20GB of unused index space in PostgreSQL

Re:An unexpected find that freed 20GB of unused index space ... by Uberphallus on Monday February 01, 2021 @12:16PM (#25990650)

Since 9 there's pg_upgrade, personally I never had an issue and it was very fast, so the downtime is in the order of a few minutes, which is ok for my usecase. YMMV.

[ Parent | on HN ]

Re:An unexpected find that freed 20GB of unused index space ... by avereveard on Monday February 01, 2021 @02:23PM (#25992492)

"pg_upgrade does its best to make sure the old and new clusters are binary-compatible, e.g., by checking for compatible compile-time settings, including 32/64-bit binaries. It is important that any external modules are also binary compatible, though this cannot be checked by pg_upgrade."

This makes me very nervous tho, I've at least two exts (trigrams and gists) maybe they work, maybe not, I just prefer the ease of mind of a old fashioned dump.

[ Parent | on HN ]

Re:An unexpected find that freed 20GB of unused index space ... by Uberphallus on Tuesday February 02, 2021 @05:18AM (#25999225)

Don't take my word for it, but I think those extensions aren't considered "external" as they're part of the PGSQL distribution.

It'd be something like nominatim.so, which is external to PGSQL and (AFAIK) has its own format for certain types of data and indexes.

[ Parent | on HN ]