Postgres Plus: the EDB blog

By Zahid Aqbal, May 02, 2016
Data replication has become a more strategic operation as datacenters expand in complexity and geographically. Data is increasingly off-loaded from transactional systems into specialized applications and databases for greater analysis or digital innovation. But by its very design, replication ...
By Matt Cicciari, Apr 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 hig ...
By Marc Linster, Apr 25, 2016
IBM recently announced RapidBuild, a reseller channel program that enables organizations to adopt trending technologies like cloud, big data and mobility—quickly and efficiently—with the help of global technology integrators.​ The first IBM partner to enroll in the RapidBuild program is ...
By Matt Cicciari, Apr 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 4 learning stages whether learning to play an i ...
By Dave Page, Apr 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 ...
By Jason Davis, Apr 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 ED ...
By Thom Brown, Apr 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 Scalabi ...
By Ahsan Hadi, Apr 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 th ...
By Thom Brown, Apr 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 thank ...
By Jamey Hanson, Mar 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 datab ...
By Thom Brown, Mar 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 followin ...
By Kevin Grittner, Mar 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 ...
By Darin Bartik, Mar 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 m ...
By Robert Haas, Mar 15, 2016
I just committed a very important patch to PostgreSQL.  The short summary for the patch is "Don't vacuum all-frozen pages." and it follows up on a patch I committed last week, whose short summary was "Change the format of the VM fork to add a second bit per page."  This led Andres Freund t ...
By Craig Guarente, Mar 09, 2016
It is fitting that the most powerful piece of advice to keep in mind when preparing to negotiate your new license agreement with Oracle is itself most commonly associated with ancient Greece’s Socrates. It is the aphorism “know thyself.” I would also add an additional element: “contro ...

Choose a Leader!

Learn why Gartner chose EnterpriseDB - an open source relational database company - to be a Leader alongside the market’s largest commercial giants.

Request report >>

Follow EnterpriseDB

Stay informed on product announcements, event information, industry news, and more!

Subscribe to the EDB blog 

Follow us on Twitter