Re: [HACKERS] logical replication - still unstable after all these months

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: [HACKERS] logical replication - still unstable after all these months
Дата
Msg-id CAMkU=1whG4nR726-vEU25m_uhWf60LpPh0riMQXVXhcjFL2jyA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] logical replication - still unstable after all thesemonths  (tushar <tushar.ahuja@enterprisedb.com>)
Список pgsql-hackers
Дерево обсуждения
On Fri, May 26, 2017 at 5:17 AM, tushar <tushar.ahuja@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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: [HACKERS] Broken hint bits (freeze)
Следующее
От: "Regina Obe"
Дата:
Сообщение: Re: [HACKERS] PostgreSQL 10 changes in exclusion constraints - did something change? CASE WHEN behavior oddity