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 ...

On 12th of February, Robert Haas committed patch: Teach ALTER TABLE .. SET DATA TYPE to avoid some table rewrites.   When the old type is binary coercible to the new type and the using clause does not change ...

Fight! But more seriously - people tend to use various data types, and there have been some myths about them, so let's see how it really boils down. First of all - All those data types are internally saved using the same ...