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
Content
Language
Level
Target Audience
Developer
Audience Requriement
Knowledge of basic SQL.
Speaker
Chung Wu
Blockchain Developer from Liker Land
Country / Region
Hong Kong
Affiliations
Liker Land
Is Remote Presentation
false