Postgres Pro
Downloads
Home   >   mailing lists

ALTER STATEMENT getting blocked - Mailing list pgsql-performance

From aditya desai
Subject ALTER STATEMENT getting blocked
Date
Msg-id CAN0SRDFCTuHU6ENsJmhxRtzLF6N4hXPONQsOtoF8ZiwNuSx+bg@mail.gmail.com
Whole thread Raw
Responses Re: ALTER STATEMENT getting blocked  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view
Hi,
We have a Postgres 11.16 DB which is continuously connected to informatica and data gets read from it continuously.

When we have to ALTER TABLE.. ADD COLUMN.. it gets blocked by the SELECTs on the table mentioned by process above. 

Is there any way to ALTER the table concurrently without  getting blocked? Any parameter or option? Can someone give a specific command?

Regards,
Aditya.

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: change the default value of enable_bitmapscan to off
Next
From: Tom Lane
Date:
Subject: Re: ALTER STATEMENT getting blocked