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.