Re: Improving the heapgetpage function improves performance in common scenarios

From: John Naylor <john(dot)naylor(at)enterprisedb(dot)com>
To: Quan Zongliang <quanzongliang(at)yeah(dot)net>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Improving the heapgetpage function improves performance in common scenarios
Date: 2023-09-05 10:46:44
Message-ID: CAFBsxsGD5_w9OjL65JFP6K6jjLAsCJhxY9B_+sPkqsMiQ9=zqQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Sep 5, 2023 at 4:27 PM Quan Zongliang <quanzongliang(at)yeah(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Guo 2023-09-05 10:50:56 Re: Should consider materializing the cheapest inner path in consider_parallel_nestloop()
Previous Message Sergei Kornilov 2023-09-05 10:38:46 whether to unlink the existing state.tmp file in SaveSlotToPath