Recently, EDB significantly optimized locking mechanisms that improved
scalability and performance in PostgreSQL 9.5. EDB further enhanced the
locking subsystems to deliver even greater performance results with an
improvement that was released with EDB Postgres Advanced Server 9.5. (Note:
Postgres supports a variety of data types that allow data architects to store
their data consistently, enforce constraints through validation, maximize
performance, and maximize space. Recently, I was asked to show someone how
to store a UUID (Universally Unique Identifier) into Postgres by ...
Organizations can reduce their database spend by 80% or more by deploying EDB
Postgres in place of traditional database solutions like Oracle, according to
calculations in a recent Gartner report. But while the benefit of redirecting
money saved is often crystal clear, the risks associated wit ...
The Dutch federal government completed a major overhaul last year of its
public health care and services systems. In the overhaul, many of the
organizational responsibilities of national systems were assigned to local
providers. To handle the demands of myriad new responsibilities, many local ...
The newest version of EDB Postgres Advanced Server® merges the recently
released community version of PostgreSQL with EDB’s enterprise-class,
open-source-based database. EDB Postgres Advanced Server is complete with
additional performance, security and management capabilities. What are the ...
Released January 7, the new PostgreSQL 9.5 ushered in a host of new features
and capabilities that boost performance, scalability and data analytics
productivity. Question: What was the most requested feature that now is
included with the new PostgreSQL 9.5? Answer: UPSERT was the most req ...
EnterpriseDB® (EDB™) works with a significant number of global brands that
deploy EDB Postgres to support complex business-critical workloads. Some of
these brands experienced a dramatic drop-offs in performance as they
dialed-up the concurrency in their load tests. This was a mystery for ...
With nearly 10 million downloads over the past five years, Postgres is the
leading enterprise open source database. In a report The State of Open Source
RDBMSs, 2015,* Gartner gives some compelling directions for IT professionals
on their road to open source. Their advice? Adopt an open source ...
This blog originally appeared on Robert Haas' personal blog. It's nice to see
that PostgreSQL 9.5 is finally released! There are a number of blog posts
out about that already, not to mention stories in InfoWorld, V3, and
a host of other publications. Of all the publicity, though, I ...
The release of PostgreSQL 9.5 marks a turning point for enterprises using
PostgreSQL for the development of high-speed mobile, web and digital economy
applications, many for customer engagement. As enterprises evolve, their
infrastructures must adapt constantly to stay competitive and meet ris ...
The number of open source software users is rising – and as Dries Buytaert,
founder of Drupal and champion of OSS famously said, “The numbers don’t
lie.” Among large- and small-to-mid-size enterprises, the demand for open
source databases is surging, as organizations seek to replicate ...
This post originally appeared on Bruce Momjian's personal blog. In 2013
I blogged about Postgres advancing in multiple directions at once. Having
presented my Postgres 9.5 features talk six times already (with
another one coming on Tuesday), I have noticed a broader pattern. Looking
A recent blog post, MongoDB 3.2: Now Powered by PostgreSQL, contained
revelations that MongoDB’s newest release, MongoDB 3.2, leverages Postgres
to power its new BI connector, designed to work with SQL-compliant data
analysis tools. However unlikely, it appears the biggest name in NoSQL has ...
This post originally appeared on Amit Kapila's personal blog. Parallelism
is now a reality in PostgreSQL. With 9.6, I hope we will see
many different forms of queries that can use parallelism to execute. For
now, I will limit this discussion to what we can already do, which is
Fifty billion connected objects will invade the market over the next five
years, according to some predictions. However, when we are talking about
connected objects, otherwise known as the Internet of Things (IoT), multiple
platforms and technological solutions come to mind. We are living i ...