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)
Quick Info
Conference
Event Type
Is Topic
Yes
Timeslots
-
Content
Language
Level
Target Audience
Developer
Audience Requriement

Knowledge of basic SQL.

Speaker
Is Remote Presentation
false