N
Neon•14mo ago
exotic-emerald

Hi, I am wondering why the following sql

Hi, I am wondering why the following sql alter table statement is taking over 10 minutes and locking up our db (adding this to a table with 2.7M rows) 
ALTER TABLE public.results ADD COLUMN updated_at TIMESTAMP;
ALTER TABLE public.results ADD COLUMN updated_at TIMESTAMP;
1 Reply
adverse-sapphire
adverse-sapphire•14mo ago
I had to cancel the operation after 22m of it just hanging and locking up the db how can I add this new column to our db w/o it locking up? from my understanding ALTER TABLE public.results ADD COLUMN updated_at TIMESTAMP; should be super fast and not lock up the db.

Did you find this page helpful?