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