Dealing with partitions in Postgres 9

explain select *
from my_table
where tenant_id = 'tenant_a'
and created_at AT TIME ZONE 'UTC' > '20171102'
and created_at AT TIME ZONE 'UTC' <= '20171103';

Solutions Architect @Depop, author of “Hands-on Design Patterns with Kotlin” book and “Web Development with Kotlin” course

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Ways to Make Money as a Developer — Videos, Job Boards, and More

Testing a browser? Being brave enough to do it. Release 0.5. Half way!

Reentrant Lock vs Synchronized Keyword In Java

A Guide to Negotiating Your Synth Programming Contract | MARDERMUSIC

AWS .. Think Storage .. The beginning .. S3

Unity: Creating a Main Menu

HNG stage one task…Goals of the program

Adding Tiled Textures Support For Adreno 3XX (Part 3)

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Alexey Soshin

Alexey Soshin

Solutions Architect @Depop, author of “Hands-on Design Patterns with Kotlin” book and “Web Development with Kotlin” course

More from Medium

Event Driven Architectures & Performance

In this blog, I am going to explain you how State store in Kafka streams is managed in…

Few practical Apache Kafka Tips

Kafka Partitions and Consumer Groups in 6 mins