Data Types to Avoid in a DISTRIBUTION KEY

posted Oct 31, 2014, 4:40 AM by Sachchida Ojha   [ updated Nov 3, 2014, 7:20 PM ]
The columns with the following data types should not be part of any DISTRIBUTION key selected for any given table:
The gadget spec URL could not be found
  1. TEXT is data type with unlimited length. A very noxious data type.
  2. DECIMAL not to be used at all in the DISTRIBUTION key
  3. DOUBLE-PRECISSION (Floating-Point binary64)
  4. REAL or real number 
  5. SERIAL mimics a good sequential number but panelizes a Singleton Select JOIN practice
  6. BIGSERIAL
  7. MONEY which stores a monetary types of data (it has been deprecated)
  8. Boolean types (0/1, true/false, etc)
Comments