Oh, and I second using same types in joins especially, very much so :)
pgsql-performance by date:
Соглашаюсь с условиями обработки персональных данных