PostgreSQL indexing: Index scan vs. Bitmap scan vs. Sequential scan (basics) - Cybertec
Server Side Events, Sequel and Postgres LISTEN/NOTIFY
Google Cloud Platform Blog: Cloud SQL for PostgreSQL adds high availability and replication
helpful overview of how high availability cloud sql postgres works
google cloud sql - Specifying the DB to connect with gcloud sql - Stack Overflow
how to specify a database when using
gcloud sql connectpostgresql - How can I change the owner of the public schema in databases created via the Google Console? - Stack Overflow
a discussion on how cloud sql (postgres) manages users, databases and permissions
Avoiding access to the public schema in PostgreSQL - Blog dbi services
In PostgreSQL every database contains the public schema by default. Every user that gets created and can login is able to create objects there. Here is a little demo: I’ll create a new user named u1 which is allowed to login. No additional privileges are granted:
PostgreSQL Privileges and Security - Locking Down the Public Schema | Severalnines
Ideas for scaling PostgreSQL to multi-terabyte and beyond - Cybertec
Feature Request : Support Postgresql 10 [71565188] - Visible to Public - Issue Tracker
Postgres 12 highlight - WITH clause and materialization
Starting with postgres 12, CTEs will no longer be an optimisation fence for many kinds of basic SELECT queries
Migrating simple table to partitioned. How? – select * from depesz;
Zero-downtime Postgres migrations - the hard parts — GoCardless Blog
When Postgres Blocks: 7 Tips for Dealing With Locks - DZone Database
ICU collations against glibc 2.28 data corruption - Cybertec
PostgreSQL and the Lock Queue | Handshake
discussion on strategies to achieve zero-downtime migrations
When Postgres blocks: 7 tips for dealing with locks
This means that even if your DDL command can run very quickly, it might be in a queue for a long time waiting for queries to finish, and queries that start after it will be blocked behind it.
PostgreSQL at Scale: Database Schema Changes Without Downtime
braintree have updated and re-released their advice on zero-downtime migrations with postgresql
BRIN Indexes – Operation | Select * from Adrien
Super helpful explanation of BRIN indexes, including how to read them in EXPLAIN ANALYZE output
Tuning checkpoints
Interesting walk through on tuning checkpoints on postgres to reduce IO. Includes graph of the effect on an RDS instance
GitHub - mgartner/pg_flame: A flamegraph generator for Postgres EXPLAIN ANALYZE output.
How to set up a single pgpool endpoint for reads and writes with Amazon Aurora PostgreSQL | AWS Database Blog
Performance best practices for using Azure Database for PostgreSQL – Connection Pooling | Blog | Microsoft Azure
Securing Amazon RDS and Aurora PostgreSQL database access with IAM authentication | AWS Database Blog
How to scale PostgreSQL 10 using table inheritance and declarative partitioning
Postgres Rocks! Powered by EDB - Upgrade your partitioning from inheritance to decl... - Postgres Rocks - 1513
How to Take Advantage of the New Partitioning Features in PostgreSQL 11 | Severalnines
PostgreSQL 11 Partitioning Improvements - pgDash
"A word of warning though: after adding a default partition, it becomes impossible to directly add another partition to cover a new range. You’ll need to detach the default partition, create the new partition, “manually” move the matching rows from the default partition to the new partition and then reattach the default partition."
Problems with PostgreSQL 10 for time-series data - Timescale - Medium
Migrating to CockroachDB
Scaling Bitbucket's Database - Bitbucket