Re: PostgreSQL 10: Call for Quotes
Robert Haas <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.advocacy |
|---|---|
| Message-ID | <CA+TgmoYu-_PFzH1GZ7qsdZqU4hvq9NRMey2fuGpRYheB6S7mRg@mail.gmail.com> |
On Thu, Aug 31, 2017 at 1:16 PM, Simon Riggs <[email protected]> wrote: > On 31 August 2017 at 17:48, Robert Haas <[email protected]> wrote: >> I would argue for >> adding Andres's executor speedups and Amit's hash index work, too > > Do we have accepted/verified perf results we can quote? Andres had a chart showing mammoth speedups on some of the TPC-H queries which he presented at PGCon. See, e.g. slide 17 at https://www.pgcon.org/2017/schedule/attachments/462_jit-pgcon-2017-05-25.pdf I don't know that that's quite formal enough for PR, but it - Q1 in particular - sure shows a nice gain. For hash indexes, the benefit is mostly that now they don't go kablooey after a crash, rather than performance, although there was performance work done as part of the project too. Not sure what the best way to showcase this would be. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-advocacy mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-advocacy