Continuing my serie of interviews with PostgreSQL Developers, i have the pleasure to talk with Mr. Bruce Monjiam (in the FAQ of his blog, he tell us that the English pronunciation of Momjian is is MOM-jin). In the past, I talk with Josh Berkus and Euler Taveira (in portuguese, only).

Bruce Momjian is a co-founder of the PostgreSQL Global Development Group, and has worked on PostgreSQL since 1996. He is the author of PostgreSQL: Introduction and Concepts, published by Addison-Wesley. Bruce is employed by EnterpriseDB. Previously, he was employed by SRA Japan and Great Bridge LLC, both PostgreSQL support companies. He has spoken at many international open-source conferences. Prior to his involvement with PostgreSQL, Bruce worked as a consultant, developing custom database applications for some of the world’s largest law firms. Prior to this, he was a high school computer science teacher and holds a Masters in Education.

1 – Which DBMS You use before know PostgreSQL?
Ingres and Informix.

2 – When did You become a PostgreSQL developer?

(from his blog in

In 1996, I had been using SQL databases at work for years, but I had no SQL database on my home Unix machine, and there weren’t any affordable ones available. I looked around and finally found PostgreSQL. It had features similar to the commercial databases I was using at work. I started using it and while it was powerful, it had lots of bugs, and the bug fixes weren’t being collected and released frequently enough. The software had potential, but it needed organization. I was always curious how SQL databases executed queries, and with PostgreSQL I could see the process in action, so I started digging into the code. I also learned a lot about programming complex applications, so I stuck around with the idea that the new skills I learned might be helpful someday, and as they say, the rest is history.

3 –
PostgreSQL change a lot since then. Which is the main features that is implemented in these years?
Uh, certainly high reliability and SQL standards, as well as easier administration and better performance.

4 – How do You see the PostgreSQL participation in the DBMS market along his history? What we could expect in the future?
Well, when I started we kind of just improved PostgreSQL to meet the needs of users. We never had any grand plan on where we were going 10 years in the future. Now we are equal in functionality to most commercial databases, and a lot of companies are using PostgreSQL. That
is certainly a new development. I imagine we will continue to have companies switching to use us.

5 – What is Your current participation on the development group of PostgreSQL?
I do mostly project administration and lots of little jobs no one else wants to do.

6 – Do You believe that the development o PostgreSQL will be done mainly by contribution of some companies like SUN, GreenPlum and EnterpriseDB, or most part of the code will be done by independent developers?
No, I think it will remain a community process, rather than company-drive. The companies involved now all realize that they can’t improve on the process we have now.

7 – The EnterpriseDB has doing a interesting job when it facilities the migration from Oracle. Which is the main features that helps the migration? Which of then we could expect to see implemented PostgreSQL in a near future?
We always had companies that wanted to switch to us but the cost of switching was more than the money they were going to save with PostgreSQL. EnterpriseDB makes switching less costly. The community doesn’t seem too worried about switching cost because we are mostly
focused on people doing new projects or people who are willing to recode their applications to work on PostgreSQL.

8 – EnterpriseDB claim to run faster than PostgreSQL. With kind of improvement are added to obtain this gain of speed?
Uh, mostly it is in automatically setting certain postgresql.conf configuration parameters, and a few improvements that will appear in the next PostgreSQL release.

9 – With contributes EnterpriseDB are done for the development of PostgreSQL?
They have assigned a number of developers to work full-time on community improvements that will be in the next release of community PostgreSQL. They have a few big features that will probably be in 8.3. They are also funding some folks to help review patches.

10 – Do You believe that in the future we will have a fusion between the non-free versions of PostgreSQL or You believe that still existing specific versions developed by companies?
I don’t see a fusion. The good news is that companies have identified where they can work to improve PostgreSQL while allowing the community to continue to grow at great speed.

11 – You write a excellent book about PostgreSQL. Today we find a little number of books about PostgreSQL, beyond the official documentation. What kind of book about PostgreSQL You would like to see been published in a near future?
Uh, good question. The Korry Douglas book seems very good. I am not sure what other books are needed. The PostgreSQL community documentation is pretty good.

12 – Replication solutions to PostgreSQL have had a lot of attention of developers at PostgreSQL history. We see a lot of projects that become dying in a few years. Slony II was a recent example. What make too many projects of this kind die so fast?

Replication is hard, a lot harder than most people think, even for the commercial database. We had a number of attempts to follow new replication research that we hoped would make replication better, but sometimes it doesn’t work properly, like Slony II. My guess is that we
are going to have to limit the number of replication things we try and take a more conservative approach.

13 – Do You believe that PGCluster II will have success? Would this be an good alternative for critical speed and fault tolerance in a heavy load transaction environment?
There was a talk about that recently at the PostgreSQL conference in Ottawa and the author said there were still performance issues with PGCluster II. We will see if these can be fixed.

14 – Do You believe that PostgreSQL will be in some day an viable option to heavy transaction environment like in banks? What is missing to this became true?
Yes, I think we are getting closer every year. We have come so far in the past 11 years that certainly we can reach that level of functionality.

15 – Could PostgreSQL be called a “generic” DBMS, or there are any specific market niche where PostgreSQL could grow?
Historically we were mostly online transaction processing (OLTP) but have added data warehousing and other features in the past few years as people asked for them. I think we will continue to spread to new areas.

3 respostas

Deixe uma resposta

plugins premium WordPress
%d blogueiros gostam disto: