On 2023-Jan-09, PG Bug reporting form wrote:
> On the REL_15_STABLE, you can hang vacuum freeze. Maybe this is not
> desired?
> https://www.postgresql.org/docs/current/pgsurgery.html
>
> reproduce script:
> create extension pg_surgery;
Using pg_surgery is the equivalent of introducing corruption in your
data. It has, of course, completely valid uses, but if you break the
system while using it, it's on you to fix it.
The pg_surgery documentation you cite states:
: These functions are unsafe by design and using them may corrupt (or
: further corrupt) your database.
So, you've been warned.
--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/
"It takes less than 2 seconds to get to 78% complete; that's a good sign.
A few seconds later it's at 90%, but it seems to have stuck there. Did
somebody make percentages logarithmic while I wasn't looking?"
http://smylers.hates-software.com/2005/09/08/1995c749.html