Re: Improving avg performance for numeric
От | Hadi Moshayedi |
---|---|
Тема | Re: Improving avg performance for numeric |
Дата | |
Msg-id | CAK=1=Wqo+6GwEhiiTjkJyrTrRvdj9nEBS+ygWW=i0-a7hmN=uQ@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Improving avg performance for numeric (Pavel Stehule <pavel.stehule@gmail.com>) |
Ответы |
Re: Improving avg performance for numeric
|
Список | pgsql-hackers |
Hello, > int, float, double 26829 ms (26675 ms) -- 0.5% slower .. statistic error .. > cleaner code > numeric sum 6490 ms (7224 ms) -- 10% faster > numeric avg 6487 ms (12023 ms) -- 46% faster I also got very similar results. On the other hand, initially I was receiving sigsegv's whenever I wanted to try to run an aggregate function. gdb was telling that this was happening somewhere in nodeAgg.c at ExecInitAgg. While trying to find the reason, I had to reboot my computer at some point, after the reboot the sigsegv's went away. I want to look into this and find the reason, I think I have missed something here. Any thoughts about why this would happen? --Hadi
В списке pgsql-hackers по дате отправления: