Thread: logical replication worker and statistics
Hi, Logical replication worker should call pgstat_report_stat()? Currently it doesn't seem to do that and no statistics about table accesses by logical replication workers are collected. For example, this can prevent autovacuum from working on those tables properly. Regards, -- Fujii Masao
On Mon, Mar 27, 2017 at 11:14 AM, Fujii Masao <masao.fujii@gmail.com> wrote: > Logical replication worker should call pgstat_report_stat()? > Currently it doesn't seem to do that and no statistics about > table accesses by logical replication workers are collected. > For example, this can prevent autovacuum from working on > those tables properly. Yeah, that doesn't sound good. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
> On 27 Mar 2017, at 18:59, Robert Haas <robertmhaas@gmail.com> wrote: > > On Mon, Mar 27, 2017 at 11:14 AM, Fujii Masao <masao.fujii@gmail.com> wrote: >> Logical replication worker should call pgstat_report_stat()? >> Currently it doesn't seem to do that and no statistics about >> table accesses by logical replication workers are collected. >> For example, this can prevent autovacuum from working on >> those tables properly. > > Yeah, that doesn't sound good. Seems that nobody is working on this, so i’m going to create the patch. Stas Kelvich Postgres Professional: http://www.postgrespro.com The Russian Postgres Company