Postgres and Open Source Experts

Anytime. Anywhere. Since 1997.

Blog

Looking for an Intermediate Sysadmin + Junior DBA

Command Prompt, Inc. is looking for an intermediate systems administrator and junior PostgreSQL administrator.

Command Prompt has provided PostgreSQL support, development, and hosting since 1997. We are looking for another person to join our stellar group of PostgreSQL systems experts.

We seek someone who has a deep knowledge of at least one UNIX-like system, and who knows how to manage heterogeneous systems well. You can demonstrate strong skills in basic …

Replication Poll results

Back before PostgreSQL Conference West, there was a poll. That poll was replication. Here are the results. There were 367 respondents. Have fun with it!

Qresponses
1In what waydo you use PostgreSQL?
Development Only72
As a hobby (or personaldevelopment)106
Professionally325
2What versionof PostgreSQL are you running?
8.3117
9.0175
8.250
8.136
8.4251
3Do you use or plan to use …

MySQL: The Elephant in the room (Facebook?), oh and me.

Rob Wultsch gave an interesting talk at PostgreSQL Conference West, about MySQL and why it doesn't suck. Yes, this was a talk we accepted at a PostgreSQL Conference. It was a good talk but some of the room was a little testy afterward.

Outside of Rob's points which I found valid (you can see it in the video) the one thing that bugged me is the aggressiveness of Facebook. It …

You still don't need no stinking replication! (Replication Poll)

So it appears my blog yesterday stirred a couple of coals. I love it. In response to Josh Berkus's comment here, I offered up a poll. So here it is: Replication Poll. You don't have to log in to take it but of course if you do, it helps track validity of results. Bring it on folks.

Users versus Customers - YOU DON'T NEED NO STINKING REPLICATION

I was catching up on the max_wal_senders must die thread and I came across this very interesting post by fellow Josh Berkus.

In the post, Josh Berkus makes the assertion, "50% of PGX's active clients have either already converted to 9.0 replication or have scheduled a conversion with us".

I have no doubts of Josh's statement but it brings up an interesting point when arguing about features in PostgreSQL. Josh's …

Are hump days, slow days? Wait ... what, No more Gnome for Ubuntu?

There are so many things to consider when working through the week. You never send a Press Release never on Monday or Friday. Scheduling meetings is always a bad idea on Monday. Thursdays always seem to be busy, probably because people want to be lazy on Friday. Monday you never know what is going to happen, you might get slammed or you might be waiting for the next email to …

PgWest 2010: Officially larger that PgEast 2010

As of 5:00PM PST PostgreSQL Conference West 2010 became the largest PostgreSQL Conference in the series. The conference is also still growing as registrations continue to come in.

Not only do we have more attendees coming to West than we did East, we have more content than we did at East. It seems that with every 6 months comes a new milestone for the series. PgWest 2010 has 3 full …

PgWest 2010: 8 Days and counting

I can't believe how far we have come from a single day, Saturday "PgDay" in 2007 to a full blown three day conference in the middle of the week. Twice a year, every year we have grown, adding content, reaching out to users, bringing the entire ecosystem together. The PgWest and PgEast conferences have grown to comprise the largest PostgreSQL conferences, anywhere.

Now that West is upon us in just …

PgWest 2010: Party Announced and Training Added!

PostgreSQL Conference West 2010 also known as PgWest, is having a party for attendees from 5:30pm to 8:30pm on November 3rd. Located on the 21st floor of the Sir Francis Drake Hotel, the 360-degree view from the Starlight Room is as breathtaking as any in the world, encompassing brilliant sunsets or rolling fog, city lights, and landmarks from Telegraph Hill to the Bay Bridge. Harry Denton's Starlight Room is the …

PgWest 2010: Anticipated talk, How To Say Yes To NoSQL: Using Redis With Postgres

There has been a lot of talk lately about this idea of "NoSQL". A lot of database traditionalists have been very down on the idea that something else is a better way to extract and store data. I have been in SQL land for so long that I can't even form a credible opinion on the matter. I know that SQL (for the most part) is logical. It makes sense …