December 6th, 2014 by depesz | Tags: benchmark, float, index, integer, numeric, performace, postgresql | 8 comments »
The general knowledge is that numerics are slower than integers/float, but offer precision and ranges that are better. While I understand what is slow, I don't really know how much slower numerics are. So let's test it.
On 11th of November, Fujii Masao committed patch: Add generate_series(numeric, numeric). Платон Малюгин Reviewed by Michael Paquier, Ali Akbar and Marti Raudsepp