Postgres Plus: the EDB blog

By Jason Davis, Apr 16, 2015
The typical data center today contains a patchwork of data management technologies. From enterprise-class relational databases to limited, standalone NoSQL-only solutions to specialized extensions, the arsenal for managing data has become more diverse. And this diverse arsenal is a business ...
By Debra Brucato, Apr 10, 2015
If you bought a new, very expensive, very powerful piece of machinery, and you were offered some training on how to best use it - you’d take it, right? Of course you would! Not only would you want to make sure you’re not a few button presses away from breaking the entire machine, but you ...
By Fred Dalrymple, Apr 07, 2015
In February of 2010, the United States Government first introduced the Cloud First Policy. Its goal was to push government services towards third party cloud computing services that could provide a host of benefits over the software stacks and services that were (and often still are) in place. ...
By Robert Haas, Apr 01, 2015
PostgreSQL has three shutdown modes: smart, fast, and immediate.  For many years, the default has been "smart", but Bruce Momjian has just committed a patch to change the default to "fast" for PostgreSQL 9.5.  In my opinion, this is a good thing; I have complained about the current, and agre ...
By Fred Dalrymple, Mar 31, 2015
It wasn’t long ago that complying with the Health Insurance Portability and Accountability Act (HIPAA) required healthcare applications to be run on-premises. To ensure health information was truly safe, it was necessary to identify the location of the specific disks that held it, and genera ...
By Ahsan Hadi, Mar 25, 2015
This blog was co-authored by Abbas Butt The research and development team in EnterpriseDB has been working hard in recent months on a solution for XA compatibility. The goal is to make our database, Postgres Plus Advanced Server compatible with the XA standard so it works with commercially a ...
By Robert Haas, Mar 18, 2015
Amit Kapila and I have been working very hard to make parallel sequential scan ready to commit to PostgreSQL 9.5.  It is not all there yet, but we are making very good progress.  I'm very grateful to everyone in the PostgreSQL community who has helped us with review and testing, and I hope ...
By Amit Kapila, Mar 18, 2015
Database Management Systems uses MVCC to avoid the problem of Writers blocking Readers and vice-versa, by making use of multiple versions of data. There are essentially two approaches to multi-version concurrency. Approaches for MVCC The first approach is to store multiple versions of r ...
By Gary Carter, Mar 02, 2015
With the most recent release of Postgres Plus Advanced Server 9.4, EnterpriseDB (EDB) has also upgraded our database enterprise management console, Postgres Enterprise Manager (PEM). The new PEM 5.0 delivers all the enterprise-class tools necessary for DBAs and Developers to easily administe ...
By Ahsan Hadi, Feb 20, 2015
This blog was co-written by Ibrar Ahmed. Advances in Postgres in recent releases have opened up opportunities for expanding features that support data integration. The most compelling of these new features are called Foreign Data Wrappers (FDWs). FDWs essentially act as a pipeline for data to ...
By Gary Carter, Feb 18, 2015
The newest release of Postgres Plus from EDB is a serious game changer for DBAs and organizations running mixed workloads on their mission critical systems. Postgres Plus Advanced Server 9.4 now features the ability to prioritize enterprise workloads to prevent a single job or group of jobs fr ...
By Robert Haas, Feb 12, 2015
A very popular standalone NoSQL database solution came under criticism about their security posture this week. It’s not the kind of publicity a database company – or any company for that matter – relishes. Although the vulnerability seems to have been less a problem with the core databas ...
By Marc Linster, Feb 03, 2015
Standalone NoSQL database solutions are easy to use, fast to deploy, and make getting an application up and running a piece of cake. That’s the sweet part though. What comes later, however, is a bellyache of solution management challenges, risks to data integrity and a loss of control in the ...
By 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 to individual Postgres features that, while useful on their own, could be comb ...
By Marc Linster, Jan 30, 2015
Two years ago, my colleague Bruce Momjian wrote that relational databases would adapt to emerging database demands and incorporate the capabilities that emerging standalone NoSQL solutions provided. He has been proven correct with the expanded capabilities in Postgres alone with recent release ...