LINKED LIST [txt mode] ▸ Fun with SQL: Recursive CTEs in Postgres

home explore | log in

Fun with SQL: Recursive CTEs in Postgres

citusdata.com · first added by @afreshcup · 2026-09-30 · 1 upvotes

log in to save, upvote or flag this.

─── In 0 lists ─────────────────────────────────────────

(not in any lists yet)

─── Discussions ────────────────────────────────────────

* Recursive Common Table Expressions in Postgres

202 pts · 97 comments · node

─── From the discussion ────────────────────────────────

* https://blog.2ndquadrant.com/postgresql-ctes-are-optimization-fences/

blog.2ndquadrant.com · node

* Nested set model - Wikipedia

en.wikipedia.org · node

* The best Postgres feature you’re not using – CTEs aka WITH clauses - CRAIG KERSTIENS

craigkerstiens.com · node

* Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems: Kleppmann, Martin: 9781449373320: Amazon.com: Books

amazon.com · node

* https://stackoverflow.com/a/46761197/2147204

stackoverflow.com · node