On Thu, Nov 16, 2023 at 7:04 AM Nikhil Ingale <niks.bgm@xxxxxxxxx> wrote:
Hi All,Hope everyone is doing well.
I would like to know how we perform/handle the bulk provisioning i.e., insert/delete/updates in Postgresql.
Bulk loading via the COPY command is very efficient.
Bulk deletes can be tricky. I'd use a CTE SELECT with LIMIT clause that fetches the PK in chunks.
