Migrating Oracle Workloads to Google Cloud - BMS
In these challenging and ever-changing times, most organizations would welcome the opportunity to...
Pythian Blog: Data Analytics, Cloud Computing, and Database Management | Valerie Parham-Thompson
Postgres partial indexes on email address domains
When I first heard of Postgres partial indexes, I knew immediately that this would have solved a...
Postgres Security Patches Related to the Search Path
There were some security patches released this month for Postgres, to put further restrictions on...
Postgres Covering Indexes and the Visibility Map
Covering indexes in Postgres came up in our weekly tech call because of a query optimization review...
PostgreSQL Backups
There are at least four ways to back up a Postgres database: SQL dump, filesystem snapshots,...
Upgrading a Large Cassandra Cluster with cstar
I recently did an upgrade of 200+ nodes of Cassandra across multiple environments sitting behind...
Spark + Cassandra Best Practices
Spark Overview Spark was created in 2009 as a response to difficulties with map-reduce in Hadoop,...
Docker Orientation
This weekend, I gave an orientation to Docker for a developer friend of mine who works in an...
Handling a Cassandra transactional workload
Overview of Cassandra As previously mentioned in my notes on lightweight transactions, Cassandra...
Cassandra backups using nodetool
Cassandra nodetool provides several types of commands to manage your Cassandra cluster. See my...
