Re: BUG #17741: vacuum process hangs after pg_surgery manipulations
От | Alvaro Herrera |
---|---|
Тема | Re: BUG #17741: vacuum process hangs after pg_surgery manipulations |
Дата | |
Msg-id | 20230116153104.u3xamywpxovvzfo4@alvherre.pgsql обсуждение исходный текст |
Ответ на | BUG #17741: vacuum process hangs after pg_surgery manipulations (PG Bug reporting form <noreply@postgresql.org>) |
Ответы |
Re: BUG #17741: vacuum process hangs after pg_surgery manipulations
|
Список | pgsql-bugs |
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
В списке pgsql-bugs по дате отправления: