Re: Optimising compactify_tuples()

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: David Rowley <dgrowleyml(at)gmail(dot)com>
Cc: Jakub Wartak <Jakub(dot)Wartak(at)tomtom(dot)com>, Peter Geoghegan <pg(at)bowt(dot)ie>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Optimising compactify_tuples()
Date: 2020-09-16 02:01:21
Message-ID: CA+hUKG+neBZG8HBT7cNEdQ5_A1v3G5E5GWtAWLoFsTNQPuycCw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Sep 16, 2020 at 1:30 PM David Rowley <dgrowleyml(at)gmail(dot)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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2020-09-16 02:09:43 Re: Optimising compactify_tuples()
Previous Message David Rowley 2020-09-16 01:29:50 Re: Optimising compactify_tuples()