Postgres Pro
Downloads
Home   >   mailing lists

pglogical performance for copying large table - Mailing list pgsql-admin

From srinivas oguri
Subject pglogical performance for copying large table
Date
Msg-id CADfH0ysqqo4zWXxjASOw6GmGjABt=g15Bu-nj76caC8hA2RwSQ@mail.gmail.com
Whole thread Raw
Responses Re: pglogical performance for copying large table  (Carrie Berlin <berlincarrie@gmail.com>)
Re: pglogical performance for copying large table  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-admin
Tree view
Hi,

I am working on migration of Aurora PostgreSQL to Ec2 with community postgresql.

I am using postgresql 12 version. Both the machines has 128 GB of ram and 32 core cpu.

I have set the parallel processes for logical replication as 12.

I am able to copy data at speed of around 8 MB/sec using pglogical.

I have dropped all indexes/triggers/constraints on destination except primary key. The table size is 2 TB. Is there any way I can improve the performance ?  

Thanks
Srinivas

pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Re: API call in SPROC
Next
From: Carrie Berlin
Date:
Subject: Re: pglogical performance for copying large table