The EDB Blog

Connecting Hadoop and EDB Postgres to Shrink Big Data Challenges

05/06/2016
EnterpriseDB ® (EDB™) has certified the EDB Postgres™ Advanced Server database for the Hortonworks Data Platform. The certification ultimately will provide organizations with a powerful solution for combining data stored in Hadoop clusters with their transactional information. This seamless view of...

5 Reasons to Review Your Disaster Recovery Plan Now

04/29/2016
Database reliability is an ongoing process, not a one-time activity. And your database disaster recovery (DR) plans are a key part of keeping your business systems reliable. However, in today’s culture that embraces the famous Ron Popeil mantra of “set it, and forget it,” maintaining highly...

Transforming the Way You Learn Postgres with Competence

04/20/2016
Noted psychologist Noel Burch developed a model called the “Four Stages for Learning Any New Skill” to better understand the often slow and uncomfortable process of learning something new. The model reveals that everyone encounters the same four learning stages whether learning to play an...

pgAdmin 4 - The Elephant Nears the Finish Line

04/18/2016
As you may know, many of us from the pgAdmin team have been hard at work on pgAdmin 4 for some time now. pgAdmin 4 is a complete rewrite of pgAdmin (the fourth, as you may guess), the previous version having reached the end of it's maintainable life after 14 years of development. Work on the...

Speeding Bulk Data Loads in Postgres

04/14/2016
EnterpriseDB ® (EDB™) developed a high-performance tool for loading data in bulk called EDB*Loader that is twice as fast as PostgreSQL COPY and outperforms standard SQL statement for bulk loading of JSONB data. The tool is part of EDB Postgres™ Advanced Server. The recent 9.5 release of EDB...

Monitoring in PostgreSQL 9.6

04/08/2016
This is part 2 in a 4 part blog series on improvements coming in PostgreSQL 9.6. Part 1 - Horizontal Scalability Join Pushdown Sort Pushdown "Walk and chew gum at the same time" Part 2 - Monitoring VACUUM progress monitoring Wait monitoring Part 3 - Parallelism Part 4 - Vertical Scalability Read...

A Little Respect for PGpool II

04/07/2016
Middleware doesn’t get the respect it deserves. Considered the glue that holds together the more complex and more business-critical components in the software stack, middleware is often installed and forgotten. But middleware can have significant impact on the operation and performance in the...

Horizontal Scalability in PostgreSQL 9.6 - Revisited

04/01/2016
In my previous blog post about horizontal scalability changes in PostrgreSQL 9.6, I covered pushing sorts and joins to the remote server, but Robert Haas (EnterpriseDB) has just committed a change that allows DML (that's UPDATEs and DELETEs) to be pushed to the remote server too. This is thanks to...

The CRUD of JSON in PostgreSQL

03/28/2016
Today’s connected enterprise requires a single database that can handle both structured and unstructured data efficiently and that adapts dynamically to swiftly changing and emerging data types. For many organizations, that database is Postgres. With JSON, Postgres can support document databases...

Horizontal Scalability in PostgreSQL 9.6

03/25/2016
PostgreSQL 9.6 is shaping up to be an impressive release, so I thought I'd try to summarise some of the big features and improvements that it will bring. This certainly won't be exhaustive, but it will touch upon areas I've looked at closely. I'm looking at breaking this down into the following...

Home on the BRIN Range

03/24/2016
There is a new index type in PostgreSQL version 9.5 called BRIN, for "Block Range Index". BRIN is an exciting feature for the 9.5 release because it can quickly organize very large tables for analysis and reporting, moving PostgreSQL deeper into the big data space. BRIN is useful where indexed data...

Open Arms for Open Source: Dell SharePlex and EnterpriseDB Team Up

03/16/2016
To say the database market is evolving would be a gross understatement. New data types and sophisticated new analytic requirements, combined with increasing pressure to lower costs without sacrificing functionality is ushering in an era of great change and great opportunity in the database market...

Building JSON Documents from Relational Tables

03/03/2016
Adoption of document databases is growing rapidly in response to the need for solutions that can handle large volumes of data. These solutions are adept at handling non-relational data models, but the distinction between database types (document, relational, key-value, etc.) is blurring...

5 Questions for Finding the Right Services Partner

02/22/2016
Smart organizations taking on a new project don’t try to go it alone – they recognize when outside help can provide the guidance needed to meet and exceed their objectives effectively. Rolling out and managing a Postgres deployment, for example, can represent a series of new challenges for an...