Re: Optimising compactify_tuples()

From: Andres Freund <andres(at)anarazel(dot)de>
To: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
Cc: David Rowley <dgrowleyml(at)gmail(dot)com>, 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 23:05:18
Message-ID: 20200916230518.ukkrfe3jswgxwiui@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2020-09-16 14:01:21 +1200, Thomas Munro wrote:
> 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.

Indeed!

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2020-09-16 23:21:37 Re: Optimising compactify_tuples()
Previous Message Alvaro Herrera 2020-09-16 22:46:14 Re: Gripes about walsender command processing