JoongHyuk Shin

Database engine developer. Writing about PostgreSQL internals, from source code to what it means for your application.

Seoul, Korea Joined on May 4, 2026 sjh910805@gmail.com

JoongHyuk Shin

May 22

1.3.3 INSERT/UPDATE/DELETE Targetlist Normalization (Default Expansion)

#postgres #database #internals #rewriter

12 min read

Want to connect with JoongHyuk Shin?

Create an account to connect with JoongHyuk Shin. You can also sign in below to proceed if you already have an account.

Create Account

Already have an account? Sign in

JoongHyuk Shin

May 17

1.3.2 How RLS Rewrites Queries (Mechanism)

#postgres #database #internals #security

11 min read

JoongHyuk Shin

May 14

1.3.1 Rule system and view expansion

#postgres #database #internals #views

11 min read

JoongHyuk Shin

May 14

1.3 Rewriter: How a Query is Rewritten

#postgres #database #internals #rewriter

2 min read

JoongHyuk Shin

May 10

1.2.3 Query tree node types: Query, RangeTblEntry, TargetEntry

#postgres #database #internals #queryplanner

7 min read

JoongHyuk Shin

May 7

1.2.2 Semantic analysis: name resolution, type checking, catalog lookup

#postgres #database #internals #sql

10 min read

JoongHyuk Shin

May 6

1.2.1 From SQL Text to Raw Parse Tree

#postgres #database #internals #parser

9 min read

JoongHyuk Shin

May 6

1.2 Parser and Analyzer: How SQL Gets Its Meaning

#postgres #database #internals #parser

2 min read

JoongHyuk Shin

May 5

1.1.3 Optimizable vs Utility

#postgres #database #internals #sql

6 min read

JoongHyuk Shin

May 5

1.1.2 Simple vs Extended

#postgres #database #internals #protocol

8 min read

JoongHyuk Shin

May 4

1.1.1 Life of a Query

#postgres #database #internals #protocol

5 min read

JoongHyuk Shin

May 4

1.1 Where Does a Query Go?

#postgres #database #internals #backend

1 min read