On Fri, Oct 27, 2023 at 7:46 PM wrote:
> Memory: 125.5 GiB of RAM
>
It looks like you have a large amount of memory allocated to the server
But your plans are doing reads instead of pulling things from shared
buffers
>explain (analyze, buffers) select count(*) from ncvhis_2016_12_03;
>
On Mon, Mar 20, 2023 at 10:21 AM Thomas Kellerer wrote:
> Inzamam Shafiq schrieb am 20.03.2023 um 13:57:
> > We have an Oracle DB which is around 1TB and we want to migrate to
> > PostgreSQL that have a new table structure, so we want to perform
> > data transformation and real time CDC from