2 ms·

First Draft of PostgreSQL 12 Release Notes

• ecnahc515 7y ago
  > Add support for the SQL/JSON path language This is pretty great. JSONPath is something used already in a bunch of places, so this knowledge will transfer well when working with JSON in PostgreSQL. Not to mention it'll be easier to understand than some of PostgreSQL's operators and functions for getting data from JSON.
• latch 7y ago
  > Allow common table expressions (CTE) to be inlined in later parts of the query If you were using CTEs before to improve readability of your selects, but weren't keeping an eye on your execution plans, this can significantly improve performance of some queries.
  • mullr 7y ago
    Alternatively, if you were using them to force a barrier in the query plan, it could completely tank. Thankfully it can be turned off, and they did this in a major release.