ALTER STATEMENT getting blocked

From: aditya desai <admad123(at)gmail(dot)com>
To: Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: ALTER STATEMENT getting blocked
Date: 2023-01-19 17:30:41
Message-ID: CAN0SRDFCTuHU6ENsJmhxRtzLF6N4hXPONQsOtoF8ZiwNuSx+bg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2023-01-19 17:45:55 Re: ALTER STATEMENT getting blocked
Previous Message Tom Lane 2023-01-14 15:57:07 Re: change the default value of enable_bitmapscan to off