Re: ALTER TABLE ADD COLUMN takes forever
| От | Devendra Yadav |
|---|---|
| Тема | Re: ALTER TABLE ADD COLUMN takes forever |
| Дата | |
| Msg-id | CAE+tJY_Xyf+k=oxy=KYo6bjnbeS0sFA4SxmYrYs=6h6toV1ebA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: ALTER TABLE ADD COLUMN takes forever (Laurenz Albe <laurenz.albe@cybertec.at>) |
| Ответы |
Re: ALTER TABLE ADD COLUMN takes forever
|
| Список | pgsql-admin |
Hello Laurenz,
Thanks for your response
We are using PostgreSQL v12.1
There are no open transactions as the table is not blocked by any pid. However when i check pg_locks it say granted=false
but nothing blocking it. Bit strange!!
but nothing blocking it. Bit strange!!
Regards,
Devendra Yadav
On Mon, 29 Mar 2021, 22:44 Laurenz Albe, <laurenz.albe@cybertec.at> wrote:
On Mon, 2021-03-29 at 22:38 +0530, Devendra Yadav wrote:
> I am running a query on a table - ALTER TABLE mytable ADD COLUMN deposited DOUBLE PRECISION DEFAULT 0.0;
>
> this query just runs forever.
Then either you are using a PostgreSQL version older than v11, or there
is an open transaction that used the table and blocks you.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
В списке pgsql-admin по дате отправления: