/Bruce Momjian

About Bruce Momjian

This author has not yet filled in any details.
So far Bruce Momjian has created 33 blog entries.

PgLife Averages Thirty Active Users

A week after the release of PgLife, the site is averaging thirty active users. (I define an active user as an IP address that has viewed the site for at least five minutes during the past hour.) I consider that a success. Since the release of PgLif...

By | May 13th, 2013|Categories: news|Comments Off on PgLife Averages Thirty Active Users

PgLife Is Now Live

New Postgres users are often confused by the variety of activities in the Postgres community. Even us old-timers can be overwhelmed in monitoring the Postgres community. To meet these two needs, I have created a website called PgLife which dynamical...

By | May 6th, 2013|Categories: news|Comments Off on PgLife Is Now Live

9.3 Release Notes Ready for Beta

I have completed the 9.3 release notes so they are ready for beta release. They will be regularly updated until 9.3 final. Post a Comment

By | May 3rd, 2013|Categories: news|Comments Off on 9.3 Release Notes Ready for Beta

Starting on 9.3 Release Notes

With our final 9.3 commit-fest almost complete, and few 9.3 open items, I have been asked to start on the 9.3 release notes. I have blogged about this process in the past (1, 2), so I will not bore you with the details. I expect to be done in a week...

By | April 12th, 2013|Categories: news|Comments Off on Starting on 9.3 Release Notes

Matching Server and Client Constraints

Postgres supports all the SQL-standard constraint types, e.g. UNIQUE, CHECK. These work fine at the server level: CREATE TABLE ledger (id SERIAL, balance NUMERIC(10,2) CHECK (balance > 0)); INSERT INTO ledger VALUES (DEFAULT, -2.00); ERROR: new...

By | April 11th, 2013|Categories: tip|Comments Off on Matching Server and Client Constraints

Dynamic Columns

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 appr...

By | April 10th, 2013|Categories: tip|Comments Off on Dynamic Columns

Pg_Upgrade Now Handles Invalid Indexes

In December, I reported that a bug had been discovered in how pg_upgrade handled invalid indexes, and that the next release of pg_upgrade would throw an error if invalid indexes were found; that release happened in February. In an easily-overlooked ...

By | April 9th, 2013|Categories: Uncategorized|Tags: |Comments Off on Pg_Upgrade Now Handles Invalid Indexes

Twenty-One Hours to Exploit

You probably heard about the important Postgres security releases (FAQ) last week, but maybe you thought it was mostly a theoretical threat. Well, the Schemaverse game author left a non-upgraded server open to the Internet to see how long it would ta...

By | April 8th, 2013|Categories: news|Comments Off on Twenty-One Hours to Exploit

Partial Indexes

Having covered expression indexes, I want to cover another index feature — partial indexes. Partial indexes allow you to create an index on part of a table. Why would you want to do that? index only frequently-accessed values, allowing smaller...

By | April 8th, 2013|Categories: tip|Comments Off on Partial Indexes

Expression Indexes

Having covered virtual columns recently, I wanted to cover one additional type of stored value, expression indexes. Unlike virtual columns, which are computed on each access, expression indexes are stored in index files, allowing rapid access. Let's...

By | April 6th, 2013|Categories: tip|Comments Off on Expression Indexes