Monthly Archives: March 2008

Python/cx_Oracle utility functions

I recently created some utility functions to startup, mount and stop Oracle via cx_Oracle and thought I would share them. You will want to make sure you have password files setup correctly in order for this stuff to work. # … Continue reading

Posted in Python | Tagged , | View Comments

Primary Keys for Slony-I

One of the prerequisites for Slony replication is to be sure that primary keys (or at least suitable columns) are defined for each table to be under replication. This is a simple example script for getting that data in postgresql. … Continue reading

Posted in PostgreSQL | Tagged , | View Comments

Memory sizing for PostgreSQL

I needed to make an assessments of a linux server’s memory footprint consumed by postgresql, however, calculating the exact memory footprint of a postgresql database is not as straightforward as one might think. Since unix utilities like top, and ps … Continue reading

Posted in Database Engineering, PostgreSQL | Tagged , | View Comments

now on WordPress

I just updated the blog to WordPress in order to get a few (ok, a lot) more features, and use the general editing environment.  I imported some of the popular posts from my old blog as well.

Posted in Random | View Comments

Python and cx_oracle

I decided to start futzing with Python and Oracle. I generally use perl for most everything, and sometimes php for web based things, but I wanted to try Python at the urging of colleagues. I downloaded the source from here, and added … Continue reading

Posted in Python | Tagged , | View Comments

Backing up Oracle optimizer statistics

Oracle 10g has some neat features for keeping track of old statistics. Pre-10g It used to be important to backup your statistics before you analyzed a table just in case your plans went crazy. Now Oracle does this for you … Continue reading

Posted in Oracle | Tagged | View Comments