On Fri, May 26, 2017 at 5:17 AM, tushar <tushar.ah...@enterprisedb.com> wrote:
> > run second time = > ./pgbench -T 20 -c 90 -j 90 -f test.sql postgres > > check the row count on master/standby > Master= > postgres=# select count(*) from pgbench_history ; > count > -------- > 536836 > (1 row) > > Standby = > > postgres=# select count(*) from pgbench_history ; > count > --------- > 1090959 > (1 row) Hi Tushar, pgbench starts out by truncating pgbench_history. That truncation does not get replicated to the subscriber. The later inserts do. So your subscriber ends up with about twice as many rows. Cheers, Jeff
