From PostgreSQL wiki
Note: lists of features to be named is not final
The PostgreSQL Global Development Group announces the release of PostgreSQL 9.0, the latest version of the world's leading open source relational database. This release features advances in security, application support, monitoring, performance and storage of specialty data. Users are particularly excited about PostgreSQL 9.0's new replication and hot standby capabilities, which will accelerate adoption in cloud hosting and scalable applications.
"The built-in replication in 9.0 and ability to query a hot standby have been the most requested PostgreSQL features for many years," said Simon Riggs, CTO of 2ndQuadrant and lead contributor to hot standby. "Efficient, low latency streaming replication protects your data better, while hot standby significantly reduces total cost of ownership. In proprietary products, this capability is an add-on costing thousands of dollars."
PostgreSQL 9.0 includes more than a dozen other major improvements that will enhance every aspect of database application design and performance, including: 64-bit Windows support, conditional and per-column triggers, upgrade-in-place from 8.3 and 8.4, deferrable unique constraints, and high-performance event messaging. For a complete list of new features, see our release information page (link).
"As one of the world's largest operators of core Internet infrastructure registries, Afilias is pleased to see PostgreSQL 9.0 add in-place upgrades, which allow us to upgrade to new versions of the database system with minimal disruption to our 16 million strong domain name database," said Afilias CTO Ram Mohan.
"We are very excited about the new features ... in particular, we look forward to the deferrable unique constraints as an opportunity to speed up updates and upgrades for our customers," said Paolo Juvara, CTO of OpenBravo.
Marc Balmer, founder of Micro Systems in Switzerland, is interested in the greatly improved LISTEN/NOTIFY event messaging capability: "The new data payload option in asynchronous notifications will power the next version of our remote data display programs."
Thanks to the contributions of developers and companies around the world, such as NTT Open Source, EnterpriseDB, 2ndQuadrant, Red Hat and many others, user adoption and development momentum is greater than ever.
"Here in CAIXA bank we use PostgreSQL in mission-critical financial environments because it has the quality to support our operations," said Clarice Coppetti, IT Vice President, CAIXA Bank, Brazil. "The new version shows that PostgreSQL is improving rapidly to keep meeting our business needs."
(For more details, see 9.0 release notes.)
Quotes for Release
Quote from Simon Riggs
"The built-in replication features in 9.0 and ability to query a hot standby have been the most requested PostgreSQL features for many years," said Simon Riggs, CTO of 2ndQuadrant. "Efficient, low latency streaming replication protects your data better, while hot standby significantly reduces total cost of ownership. In proprietary products, this capability is an add-on costing thousands of dollars."
About 2ndQuadrant: 2ndQuadrant is a global consulting and support company specializing in PostgreSQL database services, with clients in over 15 countries. The company's consultants have contributed major features in each of the last six releases of PostgreSQL. Contact: info@2ndQuadrant.com +44 8707667756
Quote from Micro Systems
Marc Balmer, founder of Micro Systems in Switzerland, is more interested in the new LISTEN/NOTIFY features: "The new data payload option in asychronous notifications will power the next version of our remote data display programs for arcapos, our ticketing and retail point of sale solution for zoos and museums."
Need an "About Micro Systems"
Quote from OpenBravo
"Openbravo has been an enthusiastic user of PostgreSQL. We embed PostgreSQL in our Cloud Appliances and we rely on PostgreSQL in our Ubuntu packages. While the product supports multiple databases, 93% of Openbravo deployments are on PostgreSQL. Every new release of PostgreSQL has delivered increased reliability and performance and we expect 9.0 to continue in that tradition. We are very excited about the new features coming with PostgreSQL. In particular, we look forward to the deferrable unique constraints as an opportunity to speed up updates and upgrades for our customers. The new built in, binary, log based replication will appeal to our larger users looking for redundancy and high availability. Finally, all of our development are looking for the new VACUUM FULL command. We have already done some preliminary testing based on PostgreSQL 9.0 and we have not found any significant issue. We detected some minor incompatibilities but we expect their resolution to be trivial. Openbravo intends to start supporting PostgreSQL 9.0 as soon as it becomes production and to start adopting it as the default deployment option as soon as it is supported in the major Linux distributions."
Paolo Juvara, CTO, OpenBravo
Obviously we will only use one sentence from the above.
About OpenBravo: Openbravo is the award-winning developer of Openbravo ERP, a web-based commercial open source ERP solution for SMBs-- the industry's first real alternative to proprietary software. The company's Enterprise Resource Planning (ERP) and Point of Sale (PoS) solutions, the most popular in their market, have been downloaded more than 1.5 million times and are used in over 50 countries. Contact: Carme Zaragoza email@example.com +34 932725947
Quote from Caixa Bank
"Here in CAIXA bank we use Postgresql in mission-critical financial environments because it has the quality to support our operations," said Clarice Coppetti, IT Vice President, CAIXA Bank, Brazil. "The new version shows that PostgreSQL is improving rapidly to keep meeting our business needs."
ABOUT CAIXA: CAIXA is the main agent for the Federal government´s public policies and is present in the life of millions of Brazilians. The Institution is 100% public and serves not only its bank clients, but the whole Brazilian population through the Lotteries, the urban infrastructure investments and the social programs payments, FGTS, PIS and Unemployment Benefit. Through all these axis, CAIXA has repassed over R$ 150 billion to the economy in 2009, an amount which represents around 6% of the GDP. By acting in the sectors of housing, basic sanitation, infrastructure and services, CAIXA plays a primordial role in the promotion of urban development and social justice in the country, contributing to improve the population´s quality of life, particularly the lower income ones.
Quote From Afilias
“As one of the world's largest operators of core Internet infrastructure registries, Afilias is pleased to see PostgreSQL 9.0 add In-Place upgrades, which allow us to upgrade to new versions of the database system with minimal disruption to our 16 million strong domain name database. In addition, we look forward to using the Hot Standby and Streaming Replication features, which supplement the robust replication already existing via Slony. These kinds of feature additions continue to make a strong case for why mission-critical technology tasks can continue to depend on the power, flexibility and robustness of PostgreSQL.” said Afilias' CTO Ram Mohan.
About Afilias: Afilias is a global provider of Internet infrastructure services that connect people to their data. Afilias' reliable, secure, scalable, and globally available technology supports a wide range of applications including Internet domain registry services, Managed DNS, and services in the RFID and supply chain market with its Afilias Discovery Services. For more information on Afilias please visit http://www.afilias.info/.
Soliciting for Further Quotes
What we want for a quote is a short but dynamic quote on any of the following three things:
- The development momentum of PostgreSQL
- HS/SR Replication and scale-out with PostgreSQL
- Some other 9.0 feature or features and how the quotee intends to use them
In the past, we've had these entities quoted:
- 8.0: Fujitsu, Hyperic
- 8.1: Pervasive, Reliable Computer Solutions
- 8.2: Bruce/EDB, Unisys, OmniTI
- 8.3: Sun, Bruce, MyYearbook.com
- 8.4: ZooLoo, Truviso, OpenStreetMap, Wisconsin Courts
This means that we've never had quotes from the following major PostgreSQL users, and should probably solicit them:
- Skype -- not possible this year
- Caixa Bank -- contacted
- FAA -- not contacted
- Enova Finanical -- not contacted
- Afilias -- contacted
- Others? Please suggest.
- Emma -- contacted
- Collaborative Software Initiative / Trisano