Top 10 EDB Postgres Blogs Posts of 2019

 

Wow it’s 2020, and here we are at the start of a new year and new decade!  We’ve clinked our champagne glasses, sung Auld Lang Syne, and made resolutions we may or may not keep (although, simply making them is half the fun). And while 2019 may already be fading into the past, EDB’s top blog posts of last year are still packed with great information that can help you in the year ahead. 

Is DocumentDB Really PostgreSQL?

Is Amazon’s fancy new MongoDB-compatible DBMS really PostgreSQL under the covers? This blog post makes a pretty compelling argument that it is.

Tips for Postgres from a Postgres Insider

This collection of Postgres tips highlights some of the more obscure features users might not be familiar with, but they can greatly enhance the use of Postgres.

Comparison of MongoDB vs. PostgreSQL

Despite the different data models that MongoDB and PostgreSQL expose, many organizations face the challenge of picking either technology. Performance is often the main deciding factor.

8 Major Improvements in PostgreSQL 12

PostgreSQL 12 is focused on performance and optimization. This release wasn’t built with brand-new, shiny features in mind; instead, it’s a finely-tuned, well-polished implementation of existing PostgreSQL capabilities.

Those Who Forget the Past Are Doomed to Repeat It

Over the past decade, a number of DBMSs have been introduced (typically labeled as NoSQL) that utilize a network or hierarchical data model. Some such systems support networks through the concepts of “links,” and some support hierarchical data using a nested data model often utilizing JSON. But it doesn’t appear that these systems have internalized lessons from history.

Postgres Table Partitioning

This blog post describes different Postgres partitioning options, how to configure partitioning, and the use cases where partitioning can be used to increase performance. It also describes other benefits of partitioning, as well as things to consider when deciding whether to use partitioning.

Pgpool vs PGBouncer

Two of the most well-known database connection poolers are Pgpool-II and PgBouncer. Each option adds functionality to a database’s connection facilities that can be used natively, but each tool includes its own particular strengths and weaknesses.

How to Run PostgreSQL on Docker

Docker is an open source platform where you can create, deploy, and run applications by using containers. See how to get started on deploying a PostgreSQL Image on Docker

MongoDB’s New License Model Won’t Save It From Competition With AWS

Last year, AWS launched Amazon DocumentDB. Look out MongoDB! Your popular DBaaS offering, Atlas, will now have to compete with Amazon on its home turf.

Comparing Oracle with EDB Postgres

It’s not often you combine open source and closed proprietary source databases in the same sentence, especially when you think about the giant in the database realm known as Oracle. But the contender, PostgreSQL, has a lot of similarities to the champion.