Postgres Pro
Downloads
Home   >   mailing lists

Re: Improving the heapgetpage function improves performance in common scenarios - Mailing list pgsql-hackers

From John Naylor
Subject Re: Improving the heapgetpage function improves performance in common scenarios
Date
Msg-id CAFBsxsGD5_w9OjL65JFP6K6jjLAsCJhxY9B_+sPkqsMiQ9=zqQ@mail.gmail.com
Whole thread Raw
In response to Re: Improving the heapgetpage function improves performance in common scenarios  (Quan Zongliang <quanzongliang@yeah.net>)
Responses Re: Improving the heapgetpage function improves performance in common scenarios
List pgsql-hackers
Tree view

On Tue, Sep 5, 2023 at 4:27 PM Quan Zongliang <quanzongliang@yeah.net> wrote:

> Here's how I test it
>     EXPLAIN ANALYZE SELECT * FROM orders;

Note that EXPLAIN ANALYZE has quite a bit of overhead, so it's not good for these kinds of tests.

> I'll also try Andres Freund's test method next.

Commit f691f5b80a85 from today removes another source of overhead in this function, so I suggest testing against that, if you wish to test again.

--
John Naylor
EDB: http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Sergei Kornilov
Date:
Subject: whether to unlink the existing state.tmp file in SaveSlotToPath
Next
From: Richard Guo
Date:
Subject: Re: Should consider materializing the cheapest inner path in consider_parallel_nestloop()