| From: | Ibrar Ahmed <ibrar(dot)ahmad(at)gmail(dot)com> |
|---|---|
| To: | Yura Sokolov <y(dot)sokolov(at)postgrespro(dot)ru>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, michail(dot)nikolaev(at)gmail(dot)com, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, Andres Freund <andres(at)anarazel(dot)de>, Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com> |
| Subject: | Re: BufferAlloc: don't take two simultaneous locks |
| Date: | 2022-09-07 07:53:07 |
| Message-ID: | CALtqXTdOUwZRLwh7Ua+EqncYa=UYBEKS1BBWmNPQLoqHfXhgmg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Jun 28, 2022 at 4:50 PM Yura Sokolov <y(dot)sokolov(at)postgrespro(dot)ru>
wrote:
> В Вт, 28/06/2022 в 14:26 +0300, Yura Sokolov пишет:
> > В Вт, 28/06/2022 в 14:13 +0300, Yura Sokolov пишет:
> >
> > > Tests:
> > > - tests done on 2 socket Xeon 5220 2.20GHz with turbo bust disabled
> > > (ie max frequency is 2.20GHz)
> >
> > Forgot to mention:
> > - this time it was Centos7.9.2009 (Core) with Linux mn10
> 3.10.0-1160.el7.x86_64
> >
> > Perhaps older kernel describes poor master's performance on 2 sockets
> > compared to my previous results (when this server had Linux 5.10.103-1
> Debian).
> >
> > Or there is degradation in PostgreSQL's master branch between.
> > I'll try to check today.
>
> No, old master commit ( 7e12256b47 Sat Mar 12 14:21:40 2022) behaves same.
> So it is clearly old-kernel issue. Perhaps, futex was much slower than this
> days.
>
>
>
> The patch requires a rebase; please do that.
Hunk #1 FAILED at 231.
Hunk #2 succeeded at 409 (offset 82 lines).
1 out of 2 hunks FAILED -- saving rejects to file
src/include/storage/buf_internals.h.rej
--
Ibrar Ahmed
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2022-09-07 07:53:55 | Re: [RFC] building postgres with meson - v12 |
| Previous Message | Ibrar Ahmed | 2022-09-07 07:50:32 | Re: Proposal: allow database-specific role memberships |