Skip to content

Greg Clough Blog

DATABASE ARCHITECTURE & SYSTEMS
  • Home
  • Articles
  • PostgreSQL
  • About Greg
  • Contact
ENGINE STATUS: POSTGRESQL CLUSTER HEALTHY

Category: codenode

Deep dives into PostgreSQL internals, relational modeling, high availability, query optimization, and enterprise infrastructure.

Home • Publications & Engineering Log
Elephant Node v16.4
CLUSTER: primary-rw
WAL_LEVEL: replica
UPTIME: 99.999%
RELATIONAL_DB
GREG CLOUGH TECH LOG
2018-01-17 Greg Clough

Babelfish for Oracle and PostgreSQL

I did a talk on the similarities and differences between Oracle and PostgreSQL at CodeNode in London: https://skillsmatter.com/skillscasts/11414-london-postgresql-january#video

Read Analysis → 0 Comments

Search Knowledge Base

PostgreSQL Cluster Stats

SHARED_BUFFERS: 16 GB
AUTOVACUUM: ACTIVE
CACHE_HIT_RATIO: 99.8%
ACTIVE_CONNECTIONS: 42

Recent Articles

  • The Garbage Collection Trap: How pg_stat_statements Garbage Collection Triggered Patroni Failovers
  • New PostgreSQL RDS versions - v10.14 , v11.9, and v12.4
  • WARNING: AWS Aurora PostgreSQL v10.12, v10.13, and v11.8 have been removed
  • Think AWS support for RDS gives 100% coverage? Think again!
  • postgresql.log file grows infinitely, and never rotates... did your disk fill up previously?

Database Topics

  • aurora
  • autovacuum
  • aws
  • bgwriter
  • buffer cache
  • bug
  • centos
  • checkpoint
  • codenode
  • database
  • dba
  • disk
  • filesystem
  • full
  • gtt
  • kill
  • log
  • log_filename
  • log_rotation_age
  • london
  • oracle
  • pg_buffercache
  • pg_ctl
  • pg_rewind
  • pg_rewind
  • postgres
  • postgres
  • postgresql
  • postgresql.conf
  • rds
  • redhat
  • rotation
  • shutdown
  • skills matter
  • slow
  • sql
  • systemd
  • temporary-tables
  • track_counts
  • Uncategorized

System Tags

postgresql sql-tuning replication sharding patroni pg_stat_statements wal-archive

Greg Clough Blog

Technical writing on high-concurrency database architecture, PostgreSQL tuning, indexing strategies, and resilient distributed data storage.

[ RELATIONAL DATA ARCHITECTURE ]

PostgreSQL Guides

  • Query Optimization & EXPLAIN ANALYZE
  • Partitioning & Sharding at Scale
  • Connection Pooling with PgBouncer
  • Logical Replication & Change Data Capture

Monthly Archives

  • October 2026
  • September 2020
  • October 2019
  • May 2019

Database Dispatch

Get Greg Clough's monthly technical briefs on PostgreSQL patch releases, benchmarks, and data patterns.

© 2026 Greg Clough Blog. Engineered with custom PostgreSQL style design.
PostgreSQL-inspired styling • Not affiliated with the PostgreSQL Global Development Group
Loading Comments...