Technology Insights

Database Scaling Terminology

Some quick explanations on designing scalable databases (thanks to Jon Sime of the PostgreSQL mailing list and Media Matters for America) Horizontal vs Vertical scaling Horizontal scaling is merely a general concept which, in its simplest form, means “adding more nodes” as opposed to vertical scaling which (very roughly) means making an individual node as…

Technology Insights

check_postgres.pl

NAME SYNOPSIS DESCRIPTION Output Modes Nagios output MRTG output Simple output DATABASE CONNECTION OPTIONS OTHER OPTIONS ACTIONS autovac_freeze backends bloat connection custom_query database_size disk_space fsm_pages fsm_relations index_size table_size relation_size last_vacuum last_autovacuum last_analyze last_autoanalyze listener locks logfile query_runtime query_time sequence replicate_row txn_time txn_idle rebuild_symlinks rebuild_symlinks_force settings_checksum timesync txn_wraparound wal_files version BASIC FILTERING USER NAME FILTERING TEST…