- 17 Key MySQL Config File Settings
- Example configuration 1
- Example configuration 2
- Example configuration 2
- Semi-sync example master
- Semi-sync example slave
- SSL Configuration Generator
- Awesome Postgres
- Lesser Known PostgreSQL Features
- SSL Configuration Generator
- UUID, serial or identity columns for PostgreSQL auto-generated primary keys
- Everything I've seen on optimizing Postgres on ZFS
- Keep Storage and Backups when Dropping Cluster with PGO
- Five Easy to Miss PostgreSQL Query Performance Bottlenecks
- PostgreSQL execution plan visualizer
- Blazing-fast cloning of PostgreSQL databases
- Postgres indexes for newbies
- Read-only mode for PostgreSQL
- Reshape - easy-to-use, zero-downtime schema migration tool for Postgres
- Vacuuming update-heavy tables
- PostgreSQL's Powerful New Join Type: LATERAL
- Hubert Lubaczewski's Blog
- OrioleDB – modern cloud-native storage engine
- How to build a job queue with Rust and PostgreSQL
- How we optimized PostgreSQL queries 100x
- Optimize PostgreSQL Server Performance Through Configuration
- Why isn't Postgres using my index?
- Our Experience with PostgreSQL on ZFS
- Generate PostgreSQL credentials with Hashicorp Vault and Go
- Use PostgreSQL SSL connection in rust with self-signed certificates
- Find and fix a missing PostgreSQL index
- 8 Fascinating Things You Probably Didn't Know PostgreSQL Can Do!
- Storing Network Addresses using PostgreSQL
- How to Find and Stop Running Queries on PostgreSQL
- Enabling and Enforcing SSL/TLS for PostgreSQL Connections
- pgwatch2 - flexible self-contained PostgreSQL metrics monitoring solution
- explain.depesz.com - PostgreSQL's explain analyze made readable
- pg_back - dump tool for PostgreSQL
- PGTune - tool for postgresql.conf generation with optimal parameters
- pgbadger - fast PostgreSQL log analyzer
- pgcopydb - pg_dump | pg_restore on steroids
- PGLoader - data loading tool for PostgreSQL using the COPY command
- Transporter - database transformations from one store to another (supports ElasticSearch, MongoDB, PostgreSQL, RabbitMQ, MySQL)
- pg_rman - online backup and restore tool for PostgreSQL
- Barman - Backup and recovery manager for PostgreSQL
- EverSQL - online SQL query optimization tool
- PGSync - PostgreSQL to Elasticsearch sync
- ALTER DATABASE db SET statement_timeout = '60s';
- CREATE EXTENSION pg_stat_statements;
- ALTER DATABASE db SET log_min_duration_statement = '100ms';
- zinc - lightweight alternative to elasticsearch that requires minimal resources
- sonic - fast, lightweight and schema-less search backend