Home > mailing lists

Re: bulk DMLs - Mailing list pgsql-admin

From	Ron Johnson
Subject	Re: bulk DMLs
Date	November 16, 2023 19:20:51
Msg-id	CANzqJaDSMQ3-=a9FZvpnDBj6ztNoFd8rsw9Q+ZzUvqyej2O3Ww@mail.gmail.com Whole thread Raw
In response to	bulk DMLs (Nikhil Ingale <niks.bgm@gmail.com>)
Responses	Re: bulk DMLs
List	pgsql-admin

On Thu, Nov 16, 2023 at 7:04 AM Nikhil Ingale <niks.bgm@gmail.com> 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.

From: Achilleas Mantzios - cloud
Date: 16 November 2023, 15:17:18
Subject: Re: Pgbouncer

From: Ron Johnson
Date: 16 November 2023, 19:32:26
Subject: Index file is growing when I drop a table. Why?