Data Types to Avoid in a DISTRIBUTION KEY

Post date: Oct 31, 2014 11:40:27 AM

The columns with the following data types should not be part of any DISTRIBUTION key selected for any given table:

• 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)