time in db

[miekg]

created_at timestamp without time zone

this should be in UTC

[thoro]

I have it in my dbs always non specified and by convention UTC

Do you think setting the time zone specified solves any specific issue? Can you give me an example?

[miekg]

If time is not in UTC, it will probably follow DST, this leads to all kind of problems when those periods are entered and left. I.e. this record was inserted at 02:30, but DST was active so actually it was 01:30.

Use UTC (and enforce!) where ever you can.