From: Devendra Yadav <devendra(dot)857(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject:
Date: 2021-03-30 07:06:15
Message-ID: CAE+tJY9xYh4EK==rGe9u9iD+z9kgDQhiQUhb4HRYDK6B5Y6TaQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2021-03-30 11:09:36 Re: ALTER TABLE blocked
Previous Message Ivan Petrov 2021-03-29 23:20:30 Improve postgres 13.2 performance for concurrent bulk insert