Postgres and Open Source Experts

Anytime. Anywhere. Since 1997.

Blog

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 …

The old Berkeley Postgres code

Some days ago, I was reading some patch from the in-progress commitfest, and happened to notice this comment in src/include/tcopprot.h:

 *    This file was created so that other c files could get the two
 *    function prototypes without having to include tcop.h which single
 *    handedly includes the whole f*cking tree -- mer 5 Nov. 1991

The weird thing about this was that there's no tcop.h file on the …

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 …

INSERT..RETURNING in postgres.js

So as you all know, we've been working on postgres support for the up-and-coming node.js environment, and we just got a great new example of Postgres' functionality that we're proud to say we support - specifically, the query format INSERT..RETURNING. For those unfamiliar with INSERT..RETURNING, this type of query allows us to do just what it says - return a value, or set of values, after an INSERT statement. This …

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 …