Pigsty Blog Articles
Incident-Report: Uneven Load Avalanche
April 08, 2018 in PostgreSQL
Recently there was a perplexing incident where a database had half its data volume and load migrated away, but ended up being overwhelmed due to increased load.
Recently there was a perplexing incident where a database had half its data volume and load migrated away, but ended up being overwhelmed due to increased load.
Bash and psql Tips
April 07, 2018 in PostgreSQL
Some tips for interacting between PostgreSQL and Bash.
Some tips for interacting between PostgreSQL and Bash.
Implementing Mutual Exclusion Constraints with Exclude
April 06, 2018 in PostgreSQL
Exclude constraint is a PostgreSQL extension that can implement more advanced and sophisticated database constraints.
Exclude constraint is a PostgreSQL extension that can implement more advanced and sophisticated database constraints.
Function Volatility Classification Levels
April 06, 2018 in PostgreSQL
PostgreSQL functions have three volatility levels by default. Proper use can significantly improve performance.
PostgreSQL functions have three volatility levels by default. Proper use can significantly improve performance.
Distinct On: Remove Duplicate Data
April 06, 2018 in PostgreSQL
Use Distinct On extension clause to quickly find records with maximum/minimum values within groups
Use Distinct On extension clause to quickly find records with maximum/minimum values within groups
PostgreSQL Routine Maintenance
February 10, 2018 in PostgreSQL
Cars need oil changes, databases need maintenance. For PG, three important maintenance tasks: backup, repack, vacuum
Cars need oil changes, databases need maintenance. For PG, three important maintenance tasks: backup, repack, vacuum
Backup and Recovery Methods Overview
February 09, 2018 in PostgreSQL
Backup is the foundation of a DBA's livelihood. With backups, there's no need to panic.
Backup is the foundation of a DBA's livelihood. With backups, there's no need to panic.
Pgbouncer Quick Start
February 07, 2018 in PostgreSQL
Pgbouncer is a lightweight database connection pool. This guide covers basic Pgbouncer configuration, management, and usage.
Pgbouncer is a lightweight database connection pool. This guide covers basic Pgbouncer configuration, management, and usage.
PgBackRest2 Documentation
February 07, 2018 in PostgreSQL
PgBackRest is a set of PostgreSQL backup tools written in Perl
PgBackRest is a set of PostgreSQL backup tools written in Perl
Changing Engines Mid-Flight — PostgreSQL Zero-Downtime Data Migration
February 06, 2018 in PostgreSQL
Data migration typically involves stopping services for updates. Zero-downtime data migration is a relatively advanced operation.
Data migration typically involves stopping services for updates. Zero-downtime data migration is a relatively advanced operation.