Home > mailing lists

Re: Bulk Insert/Update Scenario - Mailing list pgsql-general

From	Jordan Deitch
Subject	Re: Bulk Insert/Update Scenario
Date	January 5, 2018 04:03:45
Msg-id	CAK1UM_ZictBXL2Z=rOpcpSK=a7JnP0JP0Z4azG=kM+=Y5HfTFQ@mail.gmail.com Whole thread Raw
In response to	Re: Bulk Insert/Update Scenario (Mana M <manan.gcs@gmail.com>)
List	pgsql-general

INSERT .. ON CONFLICT can be ran as a bulk operation:

create table test(id int);
insert into test(id) values (1), (2), (3), (4);

Unless you mean you don't want to run this for every table?

Thanks,

Jordan Deitch

From: Mana M
Date: 05 January 2018, 03:47:49
Subject: Re: Bulk Insert/Update Scenario

From: Michael Paquier
Date: 05 January 2018, 05:04:42
Subject: Re: Replication questions - read-only and temporary read/write slaves