2023-07-29, 15:30–16:00 (Asia/Taipei), TR 310-1
Language: Traditional Chinese (Taiwan)
As a developer using Postgres, I'm occasionally meeting some interesting cases. Some unexpected crashes, some unexpected huge performance optimizations, etc. I would like to share some of the cases I met during my 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)
入門
Target Audience –-
Length of session –45 minutes