Bruce Momjian, Jun 20, 2016
Prepared statements are queries where the constants used in the query are separated from the query text. While this improves security by avoiding
Bruce Momjian, Dec 18, 2015
This post originally appeared on Bruce Momjian's personal blog.
In 2013 I blogged about Postgres advancing in multiple directions at once. Having presented ...
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:
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 ...
Bruce Momjian, Dec 14, 2012
Postgres, since version 8.2, has supported the ability to create indexes without blocking writes (insert, update, or delete) on the table being indexed. This is done by adding the keyword
Bruce Momjian, Aug 06, 2012
You might already be aware that Postgres updates the process title of all its running processes. For example, this is a Debian Linux ps display for an idle Postgres server:
postgres 2544 2543 0 10:47 ? 00:00:00 ...
Bruce Momjian, Jun 13, 2012
Object Identifiers (oids) were added to Postgres as a way to uniquely identify database objects, e.g. rows, tables, functions, etc. It is part of Postgres's