Experts in Postgres and Open Source Infrastructure

It's that time, after a wildly successful conference last October in Portland, Oregon we are now beginning to ramp up for the East Coast 08 conference! The current plan is to host a two day conference of Tutorials (new) and Talks on March 28th and 29th. The currently designated location for the conference is the Univserity of Maryland. This will be confirmed within two weeks. For now, we are making …

I have often thought that PostgreSQL logging although very flexible is also unwieldy. PostgreSQL has so many logging options, it is difficult if not impossible to find the "right" logging setting without a lot of trial and error. Let's just break it down. Below is all of the logging options available to DBAs when 8.3 hits store shelves.

#log_destination = 'stderr'		
# This is used when logging to stderr:
#logging_collector …

We had a great time at the conference and subsequent party. If you are ever in PDX and want some great food and interesting accommodations I strongly suggest the Paramount Hotel and Dragon Fish cafe. They treated all of us very well and had great food! The conference did well above expectations, signing on 10 sponsors, some at the last minute (LinuxFund). Our original goal was only 4. And as …

When Selena Deckelmann and I decided to start a PostgreSQL Conference series, we believed that a small, regional, technically specific conference was appropriate. We considered that at most, we would get around 35 people and it would essentially be a large user group meeting that had a series of talks and was good for the community. That was the end of July. It is now the night before the conference, …

Not much to say here but plphp 1.3.5 Beta1 supports named parameters and PostgreSQL 8.3 Beta1. Enjoy :) PL/php website

If you are compiling PostgreSQL from source you have a configure option called:

--enable-integer-datetimes

Now Debian/Ubuntu wisely turn this option on by default, unfortunately the RPM provided by PostgreSQL.Org and the RPM provided by RedHat/Fedora do not. Why is this a problem? I think we can all agree that given that a particular value is within a column that value should be able to be retrieved from that column. Consider …

The PostgreSQL Conference Fall 2007 has given me a knew appreciation for the little things. If it wasn't for PDXPUG leader Selena Deckelmann the conference would not have the complimentary breakfast/social nor would it have the synopsis of the talks on the conference website. The hard work of Selena, myself and the speakers appears to be paying off. We have a strong list of sponsors as well as a very …

There was a post recently on using Syslog with PostgreSQL on pgsql-general. As you can see, Tom Lane kindly replied in the thread. I decided that it might be a good idea to submit a DOC patch. I only received on comment on the patch, so I don't know if it will be applied or not. The comment, caused me to consider creating a table for the docs that correlated …

When sitting in the booth with the Army of Smurfs (tm) at OSCON 2007, I was struck by the idea that having PostgreSQL Conference(s) (yes plural) could be a great way to insure the growth of our community. Check -- duh! You would think that this is obvious. In fact I would think this is obvious. This is why the community had the Anniversary two years ago and Dan Langille …

I downloaded the latest check out of PostgreSQL 8.3 (not even beta yet) just to see how things are progressing. Of particular interest to me was a recent conversation about sequential scans I had with Jeff Davis. In short, in 8.3 sequential scans should be faster. I decided to test the theory. Using the exact same machine, and an optimized 8.1.8 installation, I compared 8.1.8 versus a out of the …