Postgres and Open Source Experts

Anytime. Anywhere. Since 1997.

Blog

More PostgreSQL Conference goodness, West 08 Keynote

This is the Keynote I gave at West 08 last October. Topics include updates on the various non-profits, reach out to tertiary communities, recognition of the importance of non direct PostgreSQL participation as well as many others (such as 8.4 and replication). Those interested in participating in the upcoming East should visit here and register.
Can we do anything more in 6 months?

Slides

Read more
Remembering excellence from past PostgreSQL Conferences

Just about 5 months ago we held PostgreSQL Conference, West 2008 in Portland Oregon. It was a very successful conference with approximate 20% growth over the previous West in 2007. It was also a three day conference over the previous West event which was a single day conference. As we prep to hold PostgreSQL Conference, East 2009 at Drexel University I wanted to look back at one of my favorite …

Read more
Pg Conference East 09, Registration open

This year is shaping up to be an even larger even than last year with 3 days, four rooms, and multiple tracks. East runs from April 3rd to April 5th at Drexel University. To register please point your Open Source web browser to PgUS. Registration is free for Students and Professors and starts at as low as 40.00 for University staff. Once you have registered make sure to visit and …

Read more
Seven things

Theo Schlossnagle recently wrote a blog post called seven things. The idea is, seven things that you "might" want to know about him. Along those lines he listed me as someone he would like to know seven things about. It has taken me a while to get to the post because I have been busy with various things. So here we go, seven things about me.
  • I have crashed …

Read more
PostgreSQL Conference: Talk deadline approaching

The deadline (Feb, 23rd) is fast approaching for PostgreSQL Conference East talk submissions. Get your talk in today!

Read more
PostgreSQL mininum requirements

In this article we will be discussing the minimum requirements for production usage of PostgreSQL whether on-prem or in the cloud. We will not be discussing proprietary forks such as Amazon RDS or other Open Source forks such as Yugabyte or Greenplum.

PostgreSQL is the Linux of databases. It provides the kernel and key features to the most critical database services available today.

Read more
What is that sound ... ... ... that is the sound of JD stomping.

After years of listening to Dave Page, Magnus Hagander, Josh Berkus, David Fetter, Stefan Kaltenbrunner, Ads, Gabrielle, JPA and numerous other contributors that I should mention but won't. I have finally submitted to get a passport. Well at least the application is filed. So let's tell a story about acquiring a passport in the United States. Generally speaking it doesn't seem to bad. I needed my birth certificate and my …

Read more
Using Simpycity in Pylons

Project Design Simpycity's core philosophy is that the DBA is going to perform the vast majority of the schema design without the aid of a conventional ORM. This is a marked divergence from most other ORMs and database abstraction layers, and it has an impact on how your project should be designed. The best results with Simpycity will be seen with a strong up-front requirements analysis, thorough schema design, and …

Read more
Configuring Pylons on Ubuntu Hardy

I recently configured a complete Pylons + PostgreSQL environment for a customer. The operating system was (of course) Ubuntu Hardy. The system included the use of Simpycity and WSGI. Although I could never done it without the Pylons documentation, I found that it was unnecessary complicated for those who just want to get it done. These are the steps I took:

Install some dependencies: The use of …

Read more
2nd call for papers: PostgreSQL Conference East!

PostgreSQL Conference East is being held at historic Drexel University on April 3rd through 5th 2009 . This is the second call for papers. The call for papers ends Feb 23rd and speakers will be notified on the 27th. You may submit your talk here. We are looking for a wide range of topics. Can you speak on any of the below topics? What about a different topic? As long …

Read more
Recent posts
Lessons from the Road: Gratitude

July 9, 2025, 9:58 a.m.

Amanda Nystrom

Part 5: Temp Tables and XID Wraparound in Single-DB Clusters

July 8, 2025, 8 a.m.

Justin Graf

Lessons from the Road: Know your footprint

July 2, 2025, 9:31 a.m.

Amanda Nystrom

Part 4: Debugging Limitations in RDS and Cloud Environments

July 1, 2025, 8 a.m.

Justin Graf

PgManage 1.3 Release: Powerful New Features and Enhanced Usability

June 25, 2025, 3 p.m.

Debbie Cerda

Part 3: Why Autovacuum Stops — PostgreSQL Internal Mechanics Explained

June 24, 2025, 6:51 p.m.

Justin Graf

Lessons from the Road: The weight of consumerism

June 18, 2025, 6:11 p.m.

Amanda Nystrom