MIME-Version: 1.0
References: <CAEzWdqcYGi0U5_cK1FVykx2-OZHmEUD8EZ_VE=kpoVaZKYWJeg@mail.gmail.com>
 <a9dd7961-dd3e-406e-a1d8-0feb233fa5e9@aklaver.com> <CAEzWdqfGN5cHN4cwSJm-rruab4E0y_9tqzihR2jQGpMXHR7cqw@mail.gmail.com>
 <b43139d3-8f8e-4635-a7cb-cab90e5205eb@aklaver.com> <CAEzWdqfts=HUoh7at7yD0M7DW97BqSe1o+4xqtXOyM_+ZX_XMA@mail.gmail.com>
 <a1abe41c-94d8-4292-899f-ea2f256d76ae@aklaver.com> <CAEzWdqdXvqYJJ0Pbb+uLKHMAEbvLb86kKW_GJ9DDrh=5MU+_GA@mail.gmail.com>
In-Reply-To: <CAEzWdqdXvqYJJ0Pbb+uLKHMAEbvLb86kKW_GJ9DDrh=5MU+_GA@mail.gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Thu, 4 Apr 2024 17:08:28 -0400
Message-ID: <CAKAnmmKKtWyy7eENvYV=HLtZ=UU475A+eUGpq7eO_1u_kL3hHw@mail.gmail.com>
Subject: Re: Moving delta data faster
To: yudhi s <learnerdatabase99@gmail.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, 
	pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000d07de806154bbf09"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmKKtWyy7eENvYV%3DHLtZ%3DUU475A%2BeUGpq7eO_1u_kL3hHw%40mail.gmail.com>
Precedence: bulk

--000000000000d07de806154bbf09
Content-Type: text/plain; charset="UTF-8"

So you want advice from this open source community about moving things from
a proprietary database to another proprietary database, going through a
proprietary storage system along the way? :)

To answer the original question, use MERGE. That's it's job, and your table
size is very tiny, so I doubt the performance impact will be worth worrying
about.

Cheers,
Greg

--000000000000d07de806154bbf09
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">So you want advice from this open source community about m=
oving things from a proprietary=C2=A0database to another proprietary databa=
se, going through a proprietary=C2=A0storage system along the way? :)<div><=
br></div><div>To answer the original question, use MERGE. That&#39;s it&#39=
;s job, and your table size is very tiny, so I doubt the performance impact=
 will be worth worrying about.</div><div><br></div><div>Cheers,</div><div>G=
reg</div><div><div><br></div></div></div>

--000000000000d07de806154bbf09--