Timestamps and Time Zones in PostgreSQL (2016)

What I like about this article is that it does something subtle yet profound: it uses repetition to solidify a concept to the reader. For example the referencing of wall time in the first few paragraphs lowers the load for the reader to refer back to previous paragraphs to reconnect with a newly introduced concept (walltime in this context was new to me as of reading this article). I think this is a huge win as it doesn’t break the reading timeline and it’s a subtle yet huge showing of attention to detail. Much kudos to the author.

Thanks, much appreciated.

At least for me, writing an article like that takes time and lots of thought (plus forces you to grok the stuff deeply). I wish I could write more often (or at least, carve out the time and energy for it), haven’t written much since.

It reads like a senior dev helping a junior where the senior dev understands the crap he or she went through to get to where they are so they break things down and use things like repetition until something sticks to help the junior dev grok it until there’s an aha moment. Keep it up!

And thank you so much for the chart[0] mapping absolute to wall time. I always have a hard time visualizing DST changes ( usually I am mentally "sliding" bars of time against each other and get confused), but that one just gave me a click.

[0] https://phili.pe/posts/timestamps-and-time-zones-in-postgres...