Hi,
This is Feng from Vitesse. Performance different between Money and Numeric is *HUGE*. For TPCH Q1, the performance difference is 5x for stock postgres, and ~20x for vitesse.
Stock postgres, for my laptop, TPCH 1G, Q1, use money type ~ 9s, use Numeric (15, 2) is ~53s.
Kevin,
test=# do $$ begin perform sum('10000.01'::numeric) from generate_series(1,10000000); end; $$;
This may not reflect the difference of the two data type. One aggregate is not where most of the time is spent. TPCH Q1 has many more computing.
