Treemaps are a nice way to visualize hierarchical data and they were actually invented to show the used space on a hard disk. I needed to present the storage usage of a database and the treemap seemed to be the natural choice. The following paragraphs show my approach to generate a treemap for the storage usage of a PostgreSQL database.Continue reading "Visualize database storage with a treemap"
Write-Ahead Logging (WAL) in PostgreSQL and Redo Logs in Oracle have some things in common. Here I want to compare both with respect to database configuration.Continue reading "PostgreSQL WAL vs. Oracle Redo Log"
I/O is more and more in focus when tuning or designing database systems for performance. Compared to the boost in computing power and network throughput over the last years we have only seen minor improvements in I/O performance at the same time. Here are some of my personal best practices when designing for performance.Continue reading "A View on Database Storage"