The Curious Engineer

All blogs / Databases

Ardent Performance Computing

ardentperf.com

Jeremy Schneider

DatabasesDevOps / SRE / infrastructurePerformance / optimizationLinux / Unix

’10’15’20’25
Posts
157 from 22 Feb 2007 to 21 Oct 2026
Posting
monthly (15 in the last year)
Kind
personal blog
Feed
https://ardentperf.com/feed/

2026 13

  1. Postgres recovery_prefetch Considered Harmful and Causing Outages
  2. Agents Gone Awry on Postgres SBOMs: Start Over
  3. Misc Learnings: SBOMs, Provenance and Attestations
  4. Why Postgres Breaks Kubernetes container_memory_working_set_bytes Metric
  5. Postgres Checkpoint Followup and Collation Visualization and Codex Luna
  6. Happiness Hint: Alarm on Checkpoint Time
  7. PGConf.dev 2026 Trip Summary
  8. Zero autovacuum_vacuum_cost_delay, Write Storms, and You
  9. Database Schema Migrations in 2026 – Survey
  10. Openclaw is Spam, Like Any Other Automated Email
  11. The Scott Shambaugh Situation Clarifies How Dumb We Are Acting
  12. Postgres client_connection_check_interval
  13. How Blocking-Lock Brownouts Can Escalate from Row-Level to Complete System Outages

2025 15

  1. Postgres Booth at PASS Data Community Summit
  2. KubeCon 2025: Bookmarks on Memory and Postgres
  3. Explaining IPC:SyncRep – Postgres Sync Replication is Not Actually Sync Replication
  4. Sanitized SQL
  5. Seattle Postgres User Group Video Library
  6. Testing CloudNativePG Preferred Data Durability
  7. Data Safety on a Budget
  8. Postgres Replication Links
  9. Losing Data is Harder Than I Expected
  10. Run Jepsen against CloudNativePG to see sync replication prevent data loss
  11. Graviton2 versus Graviton4
  12. Collation Torture Test versus Debian
  13. Waiting for Postgres 18 – Docker Containers 34% Smaller
  14. Testing loadBalancerSourceRanges with CloudNativePG on Azure Kubernetes
  15. Postgres Per-Connection Statistics

2024 8

  1. Challenges of Postgres Containers
  2. Kubernetes Requests and Limits for Postgres
  3. Good Benchmark Engineers and Postgres Benchmark Week
  4. Default Sort Order in Db2, SQL Server, Oracle & Postgres 17
  5. Major Developments in Postgres Extension Discovery and Distribution
  6. Postgres Indexes, Partitioning and LWLock:LockManager Scalability
  7. UUID Benchmark War
  8. Copy-and-Paste A New Postgres Dev Env In 5 Min

2023 3

  1. Seattle Postgres User Group and PASS Summit – PGSQL Phriday #014
  2. Did Postgres Lose My Data?
  3. Seattle User Group Thoughts and Fall Opportunities

2022 3

  1. Researching the Performance Puzzle
  2. PostgreSQL Performance Puzzle
  3. A Hairy PostgreSQL Incident

2021 2

  1. PostgreSQL Logical Replicas and Snapshots: Proceed Carefully
  2. Paranoid SQL Execution on Postgres

2019 4

  1. PostgreSQL Invalid Page and Checksum Verification Failed
  2. Seattle PostgreSQL Meetup This Thursday: New Location
  3. PostgresConf 2019 Summary
  4. PostgresConf 2019 Training Days

2018 2

  1. Column And Table Redefinition With Minimal Locking
  2. This Week in PostgreSQL – May 31

2016 1

  1. Understanding CPU on AIX Power SMT Systems

2014 7

  1. Patching Time
  2. Grid/CRS AddNode or runInstaller fails with NullPointerException
  3. OSP #3a: Build a Standard Cluster Platform
  4. Chicago Oracle User Community Restart
  5. Command Line Attachment to Oracle Support Service Request
  6. OEM CLI Commands for Bulk Property Changes
  7. November/December Highlights

2013 19

  1. Readable Code for Modify_Snapshot_Settings
  2. Largest Tables Including Indexes and LOBs
  3. OSP #2c: Build a Standard Platform from the Bottom-Up
  4. Replicating Tanel’s Script Library
  5. Convert Raw/Hex to Timestamp
  6. Delete Archived Logs from Standby
  7. OSP #2b: Build a Standard Platform from the Bottom-Up
  8. OSP #2a: Build a Standard Platform from the Bottom-Up
  9. Minimal-downtime PSUs on CRS with Cloned Golden Images
  10. Create Tablespace and ORA-28374
  11. OSP #1: The Foundation
  12. Listener Error from addNode.sh with Second Network
  13. OSP: Overview
  14. Operationally Scalable Practices
  15. Voting Disk Lies (CRS-4000)
  16. Resource Manager Limits (ORA-29376)
  17. IOUG Collaborate 2013 Wrap-Up
  18. How To Troubleshoot OEM 12c Cloud Control Auto-Discovery
  19. Set Up Exadata for Cloud Control 12.1.0.2

2012 3

  1. Adaptive Log File Sync: Oracle, Please Don’t Do That Again
  2. Lessons from Africa, Part 2
  3. Lessons From Rural Africa

2011 7

  1. Making Simple Performance Charts
  2. RAC Attack in OTN Lounge at OOW11
  3. Performance Tuning for Oracle Developers
  4. Developer Access To 10046 Trace Files
  5. Finally on Twitter
  6. RAC Attack – Oracle Cluster Database at Home
  7. BYO Oracle RAC on EC2

2010 10

  1. Binding DBLINK to a Network Interface
  2. Large ASM Adoptions and Lessons Learned
  3. OpenWorld Haiku
  4. MOTS Day 2
  5. MOTS Day 1
  6. Mysterious Oracle Net Errors
  7. RAC Investigation on Low-Memory Linux
  8. DBCA Missing – Oracle 11.2 ASM/Grid
  9. Michigan OakTable – Illinois Visitors?
  10. ASM Mirroring – No Hot Spare Disk

2009 4

  1. Five Reasons to do RAC Attack at Collaborate
  2. ASM Negative Free Space
  3. ASM Space Calculations and Hot Spares
  4. Future of OCFS2

2008 10

  1. Oracle ASM Stripe Size
  2. Robust Software Version Numbering
  3. Parsing LISTENER.ORA with awk and sed
  4. Oracle Fully Automated Install and Patch
  5. ASMLIB Performance vs Udev
  6. Collaborate Wrapup, RAC 11g/VMware Lab
  7. Oracle Services on RAC at Collaborate
  8. Oracle IOPS and HBA Queue Depth
  9. Oracle Clusterware on RHEL5/OEL5 with udev and multipath
  10. Oracle I/O and Operating System Caching

2007 46

  1. Two days until Asia! Trip Update.
  2. Cache Buffers Chains and Latch Spelunking
  3. GC Buffer Busy Waits in RAC: Finding Hot Blocks
  4. Formula for db_file_multiblock_read_count
  5. Notes on 11g New Features, Part 1
  6. Oracle 11g now on OTN for download!
  7. Log Buffer #55: a Carnival of the Vanities for DBAs
  8. 10g Subquery Unnesting Anomalies
  9. NFS and Stats Collection in Oracle 11g
  10. Compression in 11g: Time To Pay Attention
  11. Case Study: Statspack/AWR Latch Waits (Part 2)
  12. Case Study: Statspack/AWR Latch Waits (Part 1)
  13. Monitoring Oracle on SMP with Hyper-Threading
  14. Monitoring Oracle on NFS
  15. Accessing Arbitrary Ancestors in Hierarchical Queries
  16. Encyclopedia Spine Problem
  17. Combining Hierarchical Queries With Analytics
  18. Doug Burns on Oracle User Groups
  19. Chicago Oracle Users Group Meeting
  20. Controlfile Recovery WITHOUT Resetlogs
  21. Redo Log Filename Extension
  22. Fidelity Case Study
  23. Controlfile Recovery Requires RESETLOGS
  24. Recovering Your Controlfile Without a Backup
  25. Who’s Accessing That File?
  26. The Clusterware C API
  27. Migrating to RAC/ASM with RConfig
  28. E-Business Suite Applications 11i on RAC/ASM
  29. Automating Those Pesky Linux Prerequisites
  30. Listener Subscription To ONS For Cluster Events
  31. Crazy Networking Problem on Linux
  32. PRKP-1001 Converting To RAC+ASM With Rconfig
  33. LOCAL_LISTENER and ORA-12545
  34. Centralized TAF Configuration in 10g, Part 2
  35. NOT NULL Plus TAF Causing ORA-08176
  36. DBCA Slow? Check Host Equivalence.
  37. Tuning SQL Statement Execution in 10g, Part 2
  38. RAC File Permissions Quick Reference
  39. Single Oracle Password File on Raw with RAC
  40. Tuning SQL Statement Execution in 10g, Part 1
  41. Six Steps to Effective RAD
  42. Consistent Reads and Multiversioning
  43. Life Requires a Sense of Humor
  44. RAC Listener Best Practices
  45. udev for Security Conscious RAC Sysadmins
  46. Centralized TAF Configuration in 10g, Part 1