Database Engineering PostgreSQL

Memory sizing for PostgreSQL

March 11, 2008

I needed to make an assessments of a linux server’s memory footprint consumed by postgresql, however, calculating the...

Python

Python and cx_oracle

March 9, 2008

I decided to start futzing with Python and Oracle. I generally use perl for most everything, and sometimes php for we...

Oracle

Backing up Oracle optimizer statistics

March 9, 2008

Oracle 10g has some neat features for keeping track of old statistics. Pre-10g It used to be important to backup your...

Oracle

Performance Tuning: Be Proactive

June 9, 2006

I see many articles out there talking about performance tuning using the Oracle waits interface. While I am not conte...

Random

The benefits of testing

May 9, 2006

I was recently involved on a problem for a critical production database that had slow response time for inserts. The ...