| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>, Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>, Jakub Wartak <jakub(dot)wartak(at)enterprisedb(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Peter Eisentraut <peter(at)eisentraut(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Performance degradation on concurrent COPY into a single relation in PG16. |
| Date: | 2023-08-16 11:15:46 |
| Message-ID: | 20230816111546.wrkepwwjwfuottpq@alvherre.pgsql |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello,
On 2023-Aug-12, Andres Freund wrote:
> On 2023-08-08 12:45:05 +0900, Masahiko Sawada wrote:
> > > Any chance you could your benchmark? I don't see as much of a regression vs 16
> > > as you...
> >
> > Sure. The results are promising for me too:
> >
> > nclients = 1, execution time = 13.743
> > nclients = 2, execution time = 7.552
> > nclients = 4, execution time = 4.758
> > nclients = 8, execution time = 3.035
> > nclients = 16, execution time = 2.172
> > nclients = 32, execution time = 1.959
> > nclients = 64, execution time = 1.819
> > nclients = 128, execution time = 1.583
> > nclients = 256, execution time = 1.631
>
> Nice. We are consistently better than both 15 and "post integer parsing 16".
Since the wins from this patch were replicated and it has been pushed, I
understand that this open item can be marked as closed, so I've done
that.
Thanks,
--
Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/
"Hay dos momentos en la vida de un hombre en los que no debería
especular: cuando puede permitírselo y cuando no puede" (Mark Twain)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Antonin Houska | 2023-08-16 11:20:23 | Re: walsender "wakeup storm" on PG16, likely because of bc971f4025c (Optimize walsender wake up logic using condition variables) |
| Previous Message | John Naylor | 2023-08-16 11:04:34 | Re: [PoC] Improve dead tuple storage for lazy vacuum |