1
Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses
Which means, that to test it, we need some data for recursive queries. This time I took directory listing of my /etc, and loaded it to db:
Hubert depesz Lubaczewski
They wrote about logging changes to table using a trigger, but one thing that caught my attention was:
- Popular posts
- 4
- Total points
- 620
- HN comments
- 98
- Rank
- #3,995 personal
Visit depesz.com → RSS feedOn Hacker News Feb 2010 – Sep 2021
Databases & Data 4Software Engineering 3Systems & Performance 1
2
PostgreSQL 9.0 - Hot Standby, Streaming Replication
The BIG feature. The feature that made PostgreSQL leap from 8.4 to 9.0. Patch was written by Fujii Masao, and committed by Heikki Linnakangas on 15th of January 2010:
3
PostgreSQL 15: default permissions for everyone is now restricted to db owner
PostgreSQL always allowed, by default, any user to connect to any database, and create new tables (and views, and so on) in “public" schema. The one that is created by default.
4
Waiting for PostgreSQL 12 – Allow user control of CTE materialization, and change the default behavior.
This is pretty important change, as it has the chance to cause performance issues in some cases.