Hacker News
- PostgreSQL 15: default permissions for everyone is now restricted to db owner https://www.depesz.com/2021/09/10/waiting-for-postgresql-15-revoke-public-create-from-public-schema-now-owned-by-pg_database_owner/ 18 comments
- Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses https://www.depesz.com/2021/02/04/waiting-for-postgresql-14-search-and-cycle-clauses/ 65 comments
- PostgreSQL 9.5 will have native sharding http://www.depesz.com/2015/04/02/waiting-for-9-5-allow-foreign-tables-to-participate-in-inheritance/ 4 comments
- PostgreSQL 9.0 - Hot Standby, Streaming Replication http://www.depesz.com/index.php/2010/02/01/waiting-for-9-0-streaming-replication/ 15 comments
Lobsters
- How much disk space you can save by using INT4/INT instead of INT8/BIGINT? https://www.depesz.com/2022/02/13/how-much-disk-space-you-can-save-by-using-int4-int-instead-of-int8-bigint/ 3 comments databases , performance
- Waiting for PostgreSQL 15 – Add UNIQUE null treatment option https://www.depesz.com/2022/02/06/waiting-for-postgresql-15-add-unique-null-treatment-option/ 9 comments databases
- Is my autovacuum configured properly? – select * from depesz; https://www.depesz.com/2022/03/13/is-my-autovacuum-configured-properly/ 2 comments postgresql
- Find how much RAM postgres is actually using https://www.depesz.com/2012/06/09/how-much-ram-is-postgresql-using/ 2 comments postgresql
- Why is it hard to automatically suggest what index to create? – select * from depesz; https://www.depesz.com/2021/10/22/why-is-it-hard-to-automatically-suggest-what-index-to-create/ 2 comments postgresql
- Explaining the unexplainable – part 6: buffers https://www.depesz.com/2021/06/20/explaining-the-unexplainable-part-6-buffers/ 8 comments postgresql
- Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses https://www.depesz.com/2021/02/04/waiting-for-postgresql-14-search-and-cycle-clauses/ 10 comments postgresql
- Why it was hard to add upsert to Postgresql http://www.depesz.com/2012/06/10/why-is-upsert-so-complicated/ 12 comments programming
- Further optimization of the "Count distinct performance compared on top 4 SQL databases" case (link to my blog). http://www.depesz.com/2014/01/29/getting-count-of-distinct-elements-per-group-in-postgresql/ 14 comments programming
- Shortest path in pure SQL (solution in blog's comments) http://www.depesz.com/2012/06/25/how-to-get-shortest-connection-between-two-cities/ 9 comments programming
- Why is my index not being used? http://www.depesz.com/index.php/2010/09/09/why-is-my-index-not-being-used/ 5 comments programming
- Postgree 9.0! Streaming Replication & Hot Standby http://www.depesz.com/index.php/2010/02/01/waiting-for-9-0-streaming-replication/ 53 comments programming