- 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
- pgroll - PostgreSQL zero-downtime migrations made easy
- 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
- Choosing a Postgres primary key
- How to JSON in PostgreSQ
- Nine ways to shoot yourself in the foot with PostgreSQL
- The Unexpected Find That Freed 20GB of Unused Index Space
- How to Get the Most out of Postgres Memory Settings
- Postgres as a search engine
- Optimizing Postgres table layout for maximum efficiency
- What I Wish Someone Told Me About Postgres
- 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
- pg_netstat - PostgreSQL database network traffic monitor
- Pigsty - battery-included free RDS alternative
- PgHero - performance dashboard for Postgres
- An early look at HNSW performance with pgvector
- pgvector 0.5.0 feature highlights and howtos
- pgai - allows you to develop RAG, semantic search, and other AI applications directly in PostgreSQL
- pgvectorscale - complement to pgvector for high performance, cost efficient vector search on large workloads
- Timescale - AI and pgvector
- Timescale Blog
- ALTER DATABASE db SET statement_timeout = '60s';
- CREATE EXTENSION pg_stat_statements;
- ALTER DATABASE db SET log_min_duration_statement = '100ms';
wget -qO - https://www.postgresql.org/media/keys/ACCC4CF8.asc | gpg --dearmor | sudo dd of=/usr/share/keyrings/postgresql-archive-keyring.gpg
echo 'deb [ arch=amd64 signed-by=/usr/share/keyrings/postgresql-archive-keyring.gpg ] http://apt.postgresql.org/pub/repos/apt jammy-pgdg main' | sudo tee /etc/apt/sources.list.d/postgresql.list
sudo apt-get update
sudo apt-get install postgresql-client- zinc - lightweight alternative to elasticsearch that requires minimal resources
- sonic - fast, lightweight and schema-less search backend
- pg_bm25 - Elastic quality full text search inside Postgres
- bleve - modern text indexing library