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

From Peter Geoghegan
Subject Re: Optimising compactify_tuples()
Date
Msg-id CAH2-WzkLyoWNFqqfJWJzOY4toU6ba+oas399zXuc3VaTQhfoAA@mail.gmail.com
Whole thread Raw
In response to Re: Optimising compactify_tuples()  (Thomas Munro <thomas.munro@gmail.com>)
List pgsql-hackers
On Tue, Sep 15, 2020 at 7:01 PM Thomas Munro <thomas.munro@gmail.com> wrote:
> On Wed, Sep 16, 2020 at 1:30 PM David Rowley <dgrowleyml@gmail.com> wrote:
> > 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.

Yes, that's terrific.

-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: Optimising compactify_tuples()
Next
From: Amit Langote
Date:
Subject: Re: pg_restore causing deadlocks on partitioned tables