Interesting cases and tips in 2 years of Postgres experience
I want to talk about some interesting cases and tips that I met when using Postgres in my daily job, which are topics general enough that most developer may also meet in their daily jobs (even for non-Postgres developers).
- Why LIMIT 1 is MUCH SLOWER than LIMIT 100?
- What's wrong with JSONB? (hint: it's TOO robust)
- Efficient query using LATERAL subquery (from 8s to 0.08s)