SQL

Observations

• 23 Nov 2016 PostgreSQL: Two Ways to Kill Your Parallelism

  PostgreSQL 9.6 is fantastic, but here are two things that can throw cold water on your otherwise parallel queries.

• 02 Jul 2013 Sorting Children by Hierarchy with Closure Tables

  Unfortunately, this was for a well-established project built on MySQL, so the recursion and Common Table Expressions of SQL Server or PostgreSQL weren't options.