[GENERAL] Char vs SmallInt

2007-07-20 Thread Pg Coder
Which data type is smaller and will lead to better query performance - smallint or char?

[GENERAL] IN clause performance

2007-07-18 Thread Pg Coder
Basic query optimization question- does Postgres process x IN (y1, y2) as fast as (x = y1 OR x = y2) in a function?