PostgreSQL major versions are incompatible as to data format stored on disk. There is a pg_upgrade tool available but instructions for Windows aren’t directly usable. Aren Cambre fills this gap with accurate working instructions to use pg_upgrade on Windows.
Category Archives: database
Performance deficits in Apache Cassandra
Recently I was conducting an evaluation of several different databases for a messaging workload. While benchmarking Apache Cassandra, I noticed unusual patterns in performance metrics. I followed these clues and eventually found some major thread-pool design questions and a potential 18x performance gain realizable on Windows.
Continue readingCovering Indexes for Query Optimization
Covering indexes are a crucial performance technique for RDBMS optimization, and one of the most effective tools in the tuning toolbox. When large joined queries suffer from poor performance, here are some tips to tackle the situation. Continue reading
PDBs in Oracle 12: Not ready for prime-time?
Oracle 12c’s new feature is pluggable databases (PDBs). This has been introduced to improve support for cloud & multi-tenancy, and keep up with SQL Server. However, our trial found Oracle’s PDBs less than ready for production use. Continue reading