Posts Categorized: Pythian

Benchmarking Postgres on AWS 4,000 PIOPs EBS instances

Introduction Disk I/O is frequently the performance bottleneck with relational databases. With AWS recently releasing 4,000 PIOPs EBS volumes, I wanted to do some benchmarking with pgbench and PostgreSQL 9.2. Prior to this release the maximum available I/O capacity was 2,000 IOPs per volume. EBS IOPs are read and written in 16Kb chunks with their…

Supporting Feminism in Technology – Part 1

I’ve been contemplating the topic of feminism and misogyny in the technology field a lot of late.  This blog post is a culmination of a significant amount of thought and reflection on the topic of women in technology.  At Palomino, I focus a lot on the values around bringing underserved populations into technology.  Women, people…

Log Buffer #318, A Carnival of the Vanities for DBAs

News and views are an integral part of our modern daily life. When it comes to the information-hungry roles such as database professionals, such need becomes more pressing. Log Buffer is one way to keep abreast news and views from the world of Oracle, SQL Server, and MySQL.

My First 6 Months Working at Pythian

“What have I gotten myself into?” ran through my head during the first week of training at Pythian. The environment was great, the people were great, and the work was great, but many doubts ran through my head as I ran from training meeting to training meeting. How am I going to retain all this…

Opening the Door Without the Keys

This week, my DBA team fulfilled a request to restore 1 month old lost data.  A review of the RMAN backups showed that we indeed had a valid level 0 from the requested day, which was 33 days ago.  However, upon recovery, the necessary archive logs to bring the database to a consistent point were…

The Undocumented Status “M” of an RMAN Backup

It is not uncommon for Oracle to have something undocumented , and this is just another case of this ailment. We have a database in which we have two copies of the same backup: one kept in the FRA and the other in an external disk, which from time to time gets deleted from this…

IOUG Collaborate 2013 Wrap-Up

Personal highlights from Collaborate 2013 in Denver. Discussion of networking with old and new friends, technical sessions (performance forecasting and multi-block read internals) and the Pythian RAC Attack class.

Page 40 of 229« First...102030...3839404142...506070...Last »