Re: Improving the heapgetpage function improves performance in common scenarios

Поиск
Список
Период
Сортировка
От John Naylor
Тема Re: Improving the heapgetpage function improves performance in common scenarios
Дата
Msg-id CAFBsxsGD5_w9OjL65JFP6K6jjLAsCJhxY9B_+sPkqsMiQ9=zqQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Improving the heapgetpage function improves performance in common scenarios  (Quan Zongliang <quanzongliang@yeah.net>)
Ответы Re: Improving the heapgetpage function improves performance in common scenarios  (Quan Zongliang <quanzongliang@yeah.net>)
Список pgsql-hackers
Дерево обсуждения

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 по дате отправления:

Предыдущее
От: Sergei Kornilov
Дата:
Сообщение: whether to unlink the existing state.tmp file in SaveSlotToPath
Следующее
От: Richard Guo
Дата:
Сообщение: Re: Should consider materializing the cheapest inner path in consider_parallel_nestloop()