Re: Resetting spilled txn statistics in pg_stat_replication
От | Amit Kapila |
---|---|
Тема | Re: Resetting spilled txn statistics in pg_stat_replication |
Дата | |
Msg-id | CAA4eK1+SjPioikUa-8mPA5OcY9YvpM0cO-ZLOK2fnCyWOjtc2w@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Resetting spilled txn statistics in pg_stat_replication (Masahiko Sawada <masahiko.sawada@2ndquadrant.com>) |
Ответы |
Re: Resetting spilled txn statistics in pg_stat_replication
(Masahiko Sawada <masahiko.sawada@2ndquadrant.com>)
|
Список | pgsql-hackers |
On Fri, Jun 26, 2020 at 11:31 AM Masahiko Sawada <masahiko.sawada@2ndquadrant.com> wrote: > > On Thu, 25 Jun 2020 at 19:35, Amit Kapila <amit.kapila16@gmail.com> wrote: > > > > On Tue, Jun 23, 2020 at 6:39 PM Amit Kapila <amit.kapila16@gmail.com> wrote: > > > > > > On Tue, Jun 23, 2020 at 3:48 PM Tomas Vondra > > > <tomas.vondra@2ndquadrant.com> wrote: > > > > > > > > On Tue, Jun 23, 2020 at 10:58:18AM +0530, Amit Kapila wrote: > > > > >On Tue, Jun 23, 2020 at 9:32 AM Masahiko Sawada > > > > ><masahiko.sawada@2ndquadrant.com> wrote: > > > > >> > > > > >> On Sun, 21 Jun 2020 at 06:57, Tomas Vondra <tomas.vondra@2ndquadrant.com> wrote: > > > > >> > > > > > >> > > > > > > >> > >What if the decoding has been performed by multiple backends using the > > > > >> > >same slot? In that case, it will be difficult to make the judgment > > > > >> > >for the value of logical_decoding_work_mem based on stats. It would > > > > >> > >make sense if we provide a way to set logical_decoding_work_mem for a > > > > >> > >slot but not sure if that is better than what we have now. > > > > >> > > > > > > >> > > > > >> I thought that the stats are relevant to what > > > > >> logical_decoding_work_mem value was but not with who performed logical > > > > >> decoding. So even if multiple backends perform logical decoding using > > > > >> the same slot, the user can directly use stats as long as > > > > >> logical_decoding_work_mem value doesn’t change. > > > > >> > > > > Today, I thought about it again, and if we consider the point that > > logical_decoding_work_mem value doesn’t change much then having the > > stats at slot-level would also allow computing > > logical_decoding_work_mem based on stats. Do you think it is a > > reasonable assumption that users won't change > > logical_decoding_work_mem for different processes (WALSender, etc.)? > > FWIW, if we use logical_decoding_work_mem as a threshold of starting > of sending changes to a subscriber, I think there might be use cases > where the user wants to set different logical_decoding_work_mem values > to different wal senders. For example, setting a lower value to > minimize the latency of synchronous logical replication to a near-site > whereas setting a large value to minimize the amount of data sent to a > far site. > How does setting a large value can minimize the amount of data sent? One possibility is if there are a lot of transaction aborts and transactions are not large enough that they cross logical_decoding_work_mem threshold but such cases shouldn't be many. -- With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com
В списке pgsql-hackers по дате отправления:
Предыдущее
От: Amit KapilaДата:
Сообщение: Re: Transactions involving multiple postgres foreign servers, take 2