Postgres Pro
Downloads
Home   >   mailing lists

- Mailing list pgsql-admin

From Devendra Yadav
Subject
Date
Msg-id CAE+tJY9xYh4EK==rGe9u9iD+z9kgDQhiQUhb4HRYDK6B5Y6TaQ@mail.gmail.com
Whole thread Raw
Responses Re: ALTER TABLE blocked
Re:
List pgsql-admin
Tree view
Hello,

Hope everything is well with you. 

We are running on PostgreSQL v 12.1 , Redhat 7.8.
We are running a query  - ALTER TABLE mytable ADD COLUMN deposited DOUBLE PRECISION;

This query is blocked by pid 0. It's not a postgres PID and won't allow to terminate from postgres. 
What would  be the way forward to troubleshoot this?

Thanks and Regards,
Devendra Yadav

pgsql-admin by date:

Previous
From: Ivan Petrov
Date:
Subject: Improve postgres 13.2 performance for concurrent bulk insert
Next
From: Laurenz Albe
Date:
Subject: Re: ALTER TABLE blocked