Re: [HACKERS] logical replication and statistics

2017-09-27 Thread Pavel Stehule
Hi I did recheck and now it looks like it is expected. Probably I did some wrong Sorry for noise Regards Pavel

Re: [HACKERS] logical replication and statistics

2017-09-26 Thread Masahiko Sawada
On Tue, Sep 26, 2017 at 6:57 PM, Pavel Stehule wrote: > > > 2017-09-26 11:56 GMT+02:00 Pavel Stehule : >> >> >> >> 2017-09-26 11:51 GMT+02:00 Masahiko Sawada : >>> >>> On Tue, Sep 26, 2017 at 2:50 AM, Pavel Stehule >>> wrote: >>> > >>> > >>> > 2017-09-25 19:23 GMT+02:00 Petr Jelinek : >>> >> >>>

Re: [HACKERS] logical replication and statistics

2017-09-26 Thread Pavel Stehule
2017-09-26 11:56 GMT+02:00 Pavel Stehule : > > > 2017-09-26 11:51 GMT+02:00 Masahiko Sawada : > >> On Tue, Sep 26, 2017 at 2:50 AM, Pavel Stehule >> wrote: >> > >> > >> > 2017-09-25 19:23 GMT+02:00 Petr Jelinek : >> >> >> >> On 25/09/17 19:19, Tom Lane wrote: >> >> > Pavel Stehule writes: >> >>

Re: [HACKERS] logical replication and statistics

2017-09-26 Thread Pavel Stehule
2017-09-26 11:51 GMT+02:00 Masahiko Sawada : > On Tue, Sep 26, 2017 at 2:50 AM, Pavel Stehule > wrote: > > > > > > 2017-09-25 19:23 GMT+02:00 Petr Jelinek : > >> > >> On 25/09/17 19:19, Tom Lane wrote: > >> > Pavel Stehule writes: > >> >> I had two instances on one server with different port. I

Re: [HACKERS] logical replication and statistics

2017-09-26 Thread Masahiko Sawada
On Tue, Sep 26, 2017 at 2:50 AM, Pavel Stehule wrote: > > > 2017-09-25 19:23 GMT+02:00 Petr Jelinek : >> >> On 25/09/17 19:19, Tom Lane wrote: >> > Pavel Stehule writes: >> >> I had two instances on one server with different port. I am sure, so >> >> replication was functional. Only one issue is

Re: [HACKERS] logical replication and statistics

2017-09-25 Thread Pavel Stehule
2017-09-25 19:23 GMT+02:00 Petr Jelinek : > On 25/09/17 19:19, Tom Lane wrote: > > 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 primar

Re: [HACKERS] logical replication and statistics

2017-09-25 Thread Petr Jelinek
On 25/09/17 19:19, Tom Lane wrote: > 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 f

Re: [HACKERS] logical replication and statistics

2017-09-25 Thread Tom Lane
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

Re: [HACKERS] logical replication and statistics

2017-09-25 Thread Pavel Stehule
2017-09-25 18:30 GMT+02:00 Petr Jelinek : > On 25/09/17 13:33, Pavel Stehule wrote: > > > > > > 2017-09-25 13:12 GMT+02:00 Masahiko Sawada > >: > > > > On Mon, Sep 25, 2017 at 12:58 AM, Pavel Stehule > > mailto:pavel.steh...@gmail.com>> wrote: > > > Hi >

Re: [HACKERS] logical replication and statistics

2017-09-25 Thread Petr Jelinek
On 25/09/17 13:33, Pavel Stehule wrote: > > > 2017-09-25 13:12 GMT+02:00 Masahiko Sawada >: > > On Mon, Sep 25, 2017 at 12:58 AM, Pavel Stehule > mailto:pavel.steh...@gmail.com>> wrote: > > Hi > > > > I did trivial example of logical replication

Re: [HACKERS] logical replication and statistics

2017-09-25 Thread Pavel Stehule
2017-09-25 13:12 GMT+02:00 Masahiko Sawada : > On Mon, Sep 25, 2017 at 12:58 AM, Pavel Stehule > wrote: > > Hi > > > > I did trivial example of logical replication (one table, one publication, > > one subscription) > > > > I am little bit surprised so after some work - the replication is > workin

Re: [HACKERS] logical replication and statistics

2017-09-25 Thread Masahiko Sawada
On Mon, Sep 25, 2017 at 12:58 AM, Pavel Stehule wrote: > Hi > > I did trivial example of logical replication (one table, one publication, > one subscription) > > I am little bit surprised so after some work - the replication is working, > the statistics are empty > > #master > postgres=# select *

[HACKERS] logical replication and statistics

2017-09-24 Thread Pavel Stehule
Hi I did trivial example of logical replication (one table, one publication, one subscription) I am little bit surprised so after some work - the replication is working, the statistics are empty #master postgres=# select * from pg_stat_replication ; (0 rows) #slave postgres=# select * from pg_s