From: | Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-www(at)lists(dot)postgresql(dot)org |
Subject: | Re: Slower bounce-back of commit messages |
Date: | 2018-11-15 19:10:18 |
Message-ID: | 5b051550-ed85-7a21-b0a5-85524771d081@kaltenbrunner.cc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-www |
On 11/14/18 10:52 PM, Tom Lane wrote:
> It seems like sometime in the past few days, the throughput of the
> PG mail system dropped substantially. The particular symptom I'm
> noticing is that when I push multiple commits, it used to be
> that the pgsql-committers traffic came back (a) within a few seconds
> and (b) all together. Now it takes a few minutes for them to trickle in,
> as in this example of seven commits that were pushed together:
>
> From pgsql-committers-owner+M15-102287(at)lists(dot)postgresql(dot)org Wed Nov 14 16:40:31 2018
> Subject: pgsql: Doc: remove claim that all \pset format options are unique in
> From pgsql-committers-owner+M15-102288(at)lists(dot)postgresql(dot)org Wed Nov 14 16:40:35 2018
> Subject: pgsql: Doc: remove claim that all \pset format options are unique in
> From pgsql-committers-owner+M15-102292(at)lists(dot)postgresql(dot)org Wed Nov 14 16:43:57 2018
> Subject: pgsql: Doc: remove claim that all \pset format options are unique in
> From pgsql-committers-owner+M15-102289(at)lists(dot)postgresql(dot)org Wed Nov 14 16:44:20 2018
> Subject: pgsql: Doc: remove claim that all \pset format options are unique in
> From pgsql-committers-owner+M15-102290(at)lists(dot)postgresql(dot)org Wed Nov 14 16:44:34 2018
> Subject: pgsql: Doc: remove claim that all \pset format options are unique in
> From pgsql-committers-owner+M15-102293(at)lists(dot)postgresql(dot)org Wed Nov 14 16:44:43 2018
> Subject: pgsql: Make psql's "\pset format" command reject non-unique
> From pgsql-committers-owner+M15-102291(at)lists(dot)postgresql(dot)org Wed Nov 14 16:44:52 2018
> Subject: pgsql: Doc: remove claim that all \pset format options are unique in
>
> I've also noticed slower turnaround on some of the other lists.
> What's up?
we have recently spent a fair amount of effort in optimizing delivery
times for large delivery bursts (especially concurrent approvals for
mails on -announce) which caused very large load on the emailinglist box
and way too aggressive backoff in delivery afterwards.
That aggressive backoff caused excessive delays for a very large number
of recipients - the current setup copes with that scenario much better
however it puts deliveries for smaller lists (like pgsql-committers) at
a disadvantage because we stepping down aggressive deliveries a little
bit too early.
We are still working on further refining the system but as with every
optimization if you optimize for one scenario you might put another one
at a disadvantage :(
Stefan
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2018-11-16 13:55:41 | Re: postgresql-archive.org |
Previous Message | Tom Lane | 2018-11-14 21:52:17 | Slower bounce-back of commit messages |