Re: PoC Refactor AM analyse API

Поиск
Список
Период
Сортировка
От Zhihong Yu
Тема Re: PoC Refactor AM analyse API
Дата
Msg-id CALNJ-vThfHqQCkGVvipUsO_ysSxBLTNWt6LBRK=NdscVK6tXOg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PoC Refactor AM analyse API  (Denis Smirnov <sd@arenadata.io>)
Список pgsql-hackers
Denis:
Thanks for considering my suggestion.

For #1, I didn't take your example into account. Thanks for pointing that out.

Cheers

On Thu, Feb 18, 2021 at 11:59 PM Denis Smirnov <sd@arenadata.io> wrote:
Hello,  Zhihong.

Thanks for your comments.

1. I am afraid that an equivalence of "floor(val + 0.5)" to "cell(val)" is incorrect: "floor(2.1 + 0.5)" returns 2 while  "cell(2.1)" returns 3. We can’t use such replacement, as you have suggested.

2. >> For compare_rows(), it seems the computation of oa and ob can be delayed to when ba == bb (after the first two if statements).
I have checked some examples of ASM code generated by different compilers with -O2/O3 flags on https://gcc.godbolt.org and didn’t see any big benefit in result CPU instructions. You can check yourself an attached example below.



Best regards,
Denis Smirnov | Developer
sd@arenadata.io
Arenadata | Godovikova 9-17, Moscow 129085 Russia

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Dilip Kumar
Дата:
Сообщение: Re: [HACKERS] Custom compression methods
Следующее
От: Damir Simunic
Дата:
Сообщение: Re: Extensibility of the PostgreSQL wire protocol