From: | David Rowley <dgrowleyml(at)gmail(dot)com> |
---|---|
To: | John Naylor <john(dot)naylor(at)enterprisedb(dot)com> |
Cc: | Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Justin Pryzby <pryzby(at)telsasoft(dot)com>, Peter Geoghegan <pg(at)bowt(dot)ie>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Robert Haas <rhaas(at)postgresql(dot)org> |
Subject: | Re: A qsort template |
Date: | 2022-04-14 06:46:00 |
Message-ID: | CAApHDvoMQ5WMQNwQoXzOuu86gin-UbFHe88zMST6RdOGyD=vtw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, 13 Apr 2022 at 23:19, John Naylor <john(dot)naylor(at)enterprisedb(dot)com> wrote:
> More broadly than the regression, Thomas' is very often the fastest of
> all, at the cost of more binary size. David's is occasionally slower
> than v15 or v15 with revert, but much of that is a slight difference
> and some is probably noise.
Just to get an opinion from some other hardware, I've run your test
script on my AMD 3990x machine.
My opinion here is that the best thing we can learn from both of our
results is, do the patches fix the regression?
I don't believe it should be about if adding the additional
specializations performs better than skipping the tie break function
call. I think it's pretty obvious that the specializations will be
faster. I think if it was decided that v16 would be the version where
more work should be done to decide on what should be specialized and
what shouldn't be, then we shouldn't let this regression force our
hand to make that choice now. It'll be pretty hard to remove any
specializations once they've been in a released version of Postgres.
David
Attachment | Content-Type | Size |
---|---|---|
qsort-fix-regression-dgr1.ods | application/vnd.oasis.opendocument.spreadsheet | 41.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Guo | 2022-04-14 06:49:23 | Use outerPlanState macro instead of referring to leffttree |
Previous Message | John Naylor | 2022-04-14 06:36:01 | Re: Improving the "Routine Vacuuming" docs |