Upcoming Meetup: How Not To Do Postgres Connection Pooling

In May 2014, MeetMe engineers will be presenting a talk, Lessons Learned: How Not To Do Postgres Connection Pooling, for the New York City PostgreSQL User Group. In this talk, we’ll discuss real-world connection management issues encountered while running Postgres as the primary database for a top-ten social network. This includes drilling into mistakes commonly made in regard to Postgres connection management, the disasters that follow, and how to do things properly. An overview of topics involved are as follows:

  • Postgres connection management
  • Performance
  • Queueing
  • Limitations
  • PGBouncer usage and configuration

The talk, which will be held at 6:30 PM on Wednesday, May 14, 2014 and hosted at the Yodle offices, will be presented by long-time MeetMe engineers and Postgres contributors Jonah H. Harris and Michael Glaesemann, respectively the VP of Architecture and Sr. Data Architect. If you’d like to attend, please join the MeetUp! You can also get the ICS file here: New York PostgreSQL User Group Meetup.

Harnessing pgTAP in the Large

My colleague Peter Eisentraut and I had the opportunity to speak at PGConf NYC 2014. I gave a talk on how we use pgTAP as part of our Postgres test harness to unit test the PostgreSQL function API we provide to the application developers at MeetMe.

You can find the the slides at http://github.com/grzm/2014-pgconf-nyc-harnessing-pgtap.

The audience asked a lot of good questions and I got to meet some great developers. One of the benefits of speaking at a conference is interacting with the attendees and other speakers. Everyone has a different story to tell based on their own experience. It’s a wonderful way to get fresh perspectives on issues that we see in our own work.

As always, a lot of sharp minds turn out for Postgres events, challenging (in a good way!) the ideas I present, which in turn gives me the chance to reevaluate and improve what we do.

We’ll be releasing the test harness as a Ruby gem in the coming days. We’ve found it useful in providing a straightforward way to develop and test our API. There’s a lot of great work being done in the area of database testing and deployment (such as sqitch), and I’m looking forward to feedback.