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.

Yesterday I wrote about selects on int4 vs. texts. One of the comments that caught my attention was question about index creation time. So, let's see...

There is this idea that normal form in databases require you to use integer, auto incrementing, primary keys. The idea was discussed by many people, I will just point you to series of three blog posts on the subject by Josh ...

December 9th, 2008 by depesz | Tags: , , , , , , | Comments Off on Waiting for 8.4 – Default values for function arguments + integer in any base

On 4th of December Peter Eisentraut committed patch by Pavel Stehule (with Peters tweaks) which adds default values for function arguments: Default values for function arguments Pavel Stehule, with some tweaks by Peter Eisentraut