On Wed, Feb 17, 2016 at 5:22 PM, Fabien COELHO <coelho@cri.ensmp.fr> wrote:
>> \set aid 1 + 1
>> pgbench -f addition.sql -t 50000000
>>
>> I have the following:
>> HEAD: 3.5~3.7M TPS
>> list method: 3.6~3.7M TPS
>> array method: 3.4~3.5M TPS
>> So all approaches have a comparable performance.
>
> Yep, the execution trace is pretty similar in all cases, maybe with a little
> more work for the array method, although I'm surprise that the difference is
> discernable.
Nah, that's mostly noise I think. My conclusion is that all approaches
are rather equivalent for the operators.
--
Michael