| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
| Cc: | Petr Jelinek <petr(dot)jelinek(at)2ndquadrant(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: logical replication and statistics |
| Date: | 2017-09-25 17:19:49 |
| Message-ID: | 19100.1506359989@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Petr Jelinek | 2017-09-25 17:19:52 | Re: Built-in plugin for logical decoding output |
| Previous Message | Andres Freund | 2017-09-25 17:19:37 | Re: Built-in plugin for logical decoding output |