Re: Optimising compactify_tuples() - Mailing list pgsql-hackers

From Thomas Munro
Subject Re: Optimising compactify_tuples()
Date
Msg-id CA+hUKG+neBZG8HBT7cNEdQ5_A1v3G5E5GWtAWLoFsTNQPuycCw@mail.gmail.com
Whole thread Raw
In response to Re: Optimising compactify_tuples()  (David Rowley <dgrowleyml@gmail.com>)
Responses Re: Optimising compactify_tuples()  (Peter Geoghegan <pg@bowt.ie>)
Re: Optimising compactify_tuples()  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
On Wed, Sep 16, 2020 at 1:30 PM David Rowley <dgrowleyml@gmail.com> wrote:
> Thanks a lot for the detailed benchmark results and profiles. That was
> useful.  I've pushed both patches now. I did a bit of a sweep of the
> comments on the 0001 patch before pushing it.
>
> I also did some further performance tests of something other than
> recovery. I can also report a good performance improvement in VACUUM.
> Something around the ~25% reduction mark

Wonderful results.  It must be rare for a such a localised patch to
have such a large effect on such common workloads.



pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: Optimising compactify_tuples()
Next
From: Peter Geoghegan
Date:
Subject: Re: Optimising compactify_tuples()