I decided to use the timestamp type, but this may have been a mistake! There is no btree index for timestamp, but there is for datetime?!?! I suppose I could write one...
pgsql-hackers by date:
Соглашаюсь с условиями обработки персональных данных