From: | Andres Freund <andres(at)anarazel(dot)de> |
---|---|
To: | Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [PATCH] Make sure all statistics is sent after a few DML are performed |
Date: | 2017-07-21 11:58:47 |
Message-ID: | 20170721115847.in72r7h7rop2dswa@alap3.anarazel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
(please don't top-reply on this list)
On 2017-07-19 14:04:39 +0900, Yugo Nagata wrote:
> On Tue, 18 Jul 2017 10:10:49 -0400
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Thank you for your comments. I understand the problem of my proposal
> patch.
Does that mean you're trying to rewrite it in the way that was
suggested:
> > > Another,
> > > pretty half-baked, approach would be to add a procsignal triggering idle
> > > backends to send stats, and send that to all idle backends when querying
> > > stats. We could even publish the number of outstanding stats updates in
> > > PGXACT or such, without any locking, and send it only to those that have
> > > outstanding ones.
> >
> > If somebody wanted to do the work, that'd be a viable answer IMO. You'd
> > really want to not wake backends that have nothing more to send, but
> > I agree that it'd be possible to advertise that in shared memory.
or are you planning to just let the issue leave be?
- Andres
From | Date | Subject | |
---|---|---|---|
Next Message | Alexey Chernyshov | 2017-07-21 12:05:53 | [PATCH] Pageinspect - add functions on GIN and GiST indexes from gevel |
Previous Message | Alik Khilazhev | 2017-07-21 11:51:00 | Re: [WIP] Zipfian distribution in pgbench |