Bruce

Author Archive: Bruce Momjian
Bruce Momjian, Senior Database Architect

Bruce Momjian is a co-founder of the PostgreSQL Global Development Group, and has worked on PostgreSQL since 1996 as a committer and community leader. He is the author of PostgreSQL: Introduction and Concepts, published by Addison-Wesley. Bruce is employed by EnterpriseDB as a Senior Database Architect.

Bruce Momjian, Feb 01, 2015
As a followup to my scaling talk, I have written a draft of another talk, The Future of Postgres Sharding. It starts by explaining the advantages of sharding as a scaling option. It then covers future enhancements ...
Bruce Momjian, Nov 11, 2014
I just returned from two weeks in Russia, and I am happy to report that Postgres is experiencing strong growth there. I have regularly complained that Russian Postgres adoption was lagging, but the
Bruce Momjian, Nov 04, 2014
Due to the increased popularity of Postgres, conference organizers are more confident about future conferences and are announcing their conference dates earlier, perhaps also to attract speakers. These are the conferences already announced for 2015: February,
Bruce Momjian, Oct 24, 2014
PostgreSQL Conference Europe has just finished and I delivered two new presentations at the conference (a first for me). Postgres Scaling Opportunities summarizes scaling options, ...
Bruce Momjian, Jun 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 (
Bruce Momjian, Apr 06, 2014
I just returned from attending PGConf NYC. They had 259 participants, more than double last year's total. The ...
Bruce Momjian, Mar 01, 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
Bruce Momjian, Feb 26, 2014
EnterpriseDB decided to put me on the spot recently by inviting queries from the community via social channels as I prepared for teaching a new PostgreSQL course. It’s a familiar spot for me. I regularly field questions about PostgreSQL given my role in the community and I was happy to get a question through ...
Bruce Momjian, Apr 10, 2013
Sql has never been good at handling dynamic columns — it can easily process tables with a fixed number of columns, but dynamic column handling has always been a challenge. (Dynamic columns are often used to implement user-defined fields.) One approach has been to define columns for ...
Bruce Momjian, Apr 01, 2013
Databases store data in table columns, but sometimes it is useful to create non-storage columns for code clarity. For example, you might need to access a combination of columns frequently and don't want to repeatedly perform the combining operation in your application. In this case, a column can be created that acts as a virtual ...