Postgres stuck with ALTER query onp roduction
0
votes
1
answer
142
views
So I have this big database in production having partitions on date field.
I ran this migration to add a new column and its now 1-hour db is stuck not responding and still migrating.
ALTER TABLE public.ur_sms_traffic ADD COLUMN trace_id varchar(16);
The table has no relation. just stand-alone table,
Asked by Shaz Hemani
(101 rep)
Dec 15, 2021, 08:41 AM
Last activity: Jul 19, 2025, 09:05 PM
Last activity: Jul 19, 2025, 09:05 PM