Bruce Momjian

Postgres Blog


This blog is about my work on the Postgres open source database, and is published on Planet PostgreSQL. PgLife allows monitoring of all Postgres community activity.

Online status:
Unread Postgres emails:
Email graphs: incoming, outgoing, unread, commits (details), events



News Postgres Pool Party

Saturday, June 14, 2014

If you are near Philadelphia, you are invited to attend the 2014 Postgres Pool Party at my home:

  • When: Saturday, July 26, 2pm to 7pm
  • Where: my home in Newtown Square, Pennsylvania (directions)
  • What: barbecue, swimming, and good conversation

All Postgres users, developers, and groupies are invited, including their families. Please rsvp via email by July 20.

 


Conference Postgres Gets the Business

Sunday, April 6, 2014

I just returned from attending PGConf NYC. They had 259 participants, more than double last year's total. The conference was in a hotel near Wall Street.

While I have been to many Postgres user conferences, this felt like my first corporate Postgres conference. Presenters from multinational banks Goldman Sachs and Morgan Stanley explained how and why they use Postgres in their organizations. These are trend-setting organizations, and their public embrace of Postgres will have lasting benefits.

In fact, one hallway discussion was how to enable large organizations like these, particularly those with significant legal and regulatory requirements, to work with the Postgres community. Some companies have employees post from non-company email accounts like Gmail, while others contract with consulting companies to work with the Postgres community on their behalf. Unfortunately, neither of these approaches have the companies working with the community openly. There were also many requests for improved auditing.

Another business-oriented aspect of the conferences was a dedicated security track. As part of that, Denish Patel's PCI Compliance talk (slides) dispelled much of the confusion around PCI compliance.

I was able to present a new talk at the conference, Making Postgres Central in Your Data Center. It explains how Postgres is uniquely positioned to be a central data broker.

For me, this conference was a clear sign of significant Postgres growth in the months ahead.

Post a Comment

Conference Integrated Cache Invalidation for Better Hit Rates

Saturday, March 1, 2014

I just attended and presented at ConFoo, where I always learn new things. This year, the best talk I attended was by our own Magnus Hagander. Called Integrated Cache Invalidation for Better Hit Rates, it addresses the difficult task of controlling web page cache refresh by providing a reliable mechanism for invalidating the cache when the database changes. It shows how to use triggers and pgq to communicate changes to a Varnish web frontend.

Caching in front of a database is often risky. However, with triggers, pgq, and Varnish, proper invalidation can be accomplished, dramatically increasing the scalability of database-backed websites.

Post a Comment