| From: | Hadi Moshayedi <hadi(at)moshayedi(dot)net> |
|---|---|
| To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Improving avg performance for numeric |
| Date: | 2013-08-29 05:09:15 |
| Message-ID: | CAK=1=Wqo+6GwEhiiTjkJyrTrRvdj9nEBS+ygWW=i0-a7hmN=uQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2013-08-29 05:48:45 | Re: Improving avg performance for numeric |
| Previous Message | Noah Misch | 2013-08-29 02:30:34 | Re: Valgrind Memcheck support |