pglogical performance on large number of tables

2ndQuadrant / pglogical

Logical Replication extension for PostgreSQL 17, 16, 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.

http://2ndquadrant.com/en/resources/pglogical/

Other

1.01k stars 153 forks source link

pglogical performance on large number of tables #322

Open carolfly86 opened 3 years ago

carolfly86 commented 3 years ago

Hi, We are evaluating using pglogical on a Database with thousands of tables from 300+ schemas. Would that cause and performance bottle neck?

petere commented 3 years ago

It can work, but you need to try it out to know for sure.