"Pg Coder" <[EMAIL PROTECTED]> writes: > Which data type is smaller and will lead to better query performance - > smallint or char?
smallint is 2 bytes, usually with 2-byte alignment. If you declare a column as char it means CHAR(1) which in 8.2 is 5-8 bytes (5 bytes if it's an ascii character) and has 4-byte alignment. In 8.3 it's 2-5 bytes (2 bytes if it's an ascii character) and has 1-byte alignment. If you declare a column as "char" with the quotes then it's a 1-byte integer with 1-byte alignment. That'll be smaller than smallint. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
