Re: [HACKERS] logical replication and statistics

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: [HACKERS] logical replication and statistics
Дата
Msg-id
19100.1506359989@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
[HACKERS] logical replication and statistics Pavel Stehule <pavel.stehule@gmail.com>
Re: [HACKERS] logical replication and statistics Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] logical replication and statistics Pavel Stehule <pavel.stehule@gmail.com>
Re: [HACKERS] logical replication and statistics Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] logical replication and statistics Pavel Stehule <pavel.stehule@gmail.com>
Re: [HACKERS] logical replication and statistics Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] logical replication and statistics Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] logical replication and statistics Pavel Stehule <pavel.stehule@gmail.com>
Re: [HACKERS] logical replication and statistics Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] logical replication and statistics Pavel Stehule <pavel.stehule@gmail.com>
Re: [HACKERS] logical replication and statistics Pavel Stehule <pavel.stehule@gmail.com>
Re: [HACKERS] logical replication and statistics Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] logical replication and statistics Pavel Stehule <pavel.stehule@gmail.com>
Pavel Stehule  writes:
> I had two instances on one server with different port. I am sure, so
> replication was functional. Only one issue is statistics

> Master:

> CREATE TABLE foo(id int primary key, a int);
> CREATE PUBLICATION test_pub FOR TABLE foo;
> INSERT INTO foo VALUES(1, 200);

> slave

> CREATE TABLE foo(id int primary key, a int);
> CREATE SUBSCRIPTION test_sub CONNECTION 'port=5432' PUBLICATION test_pub;

> That was all

In this example, nothing's been done yet by the actual replication
apply process, only by the initial table sync.  Maybe that accounts
for your not seeing stats?
		regards, tom lane


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
В списке pgsql-hackers по дате отправления
От: Andres Freund
Дата:
От: Petr Jelinek
Дата:
FAQ