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 Amazon’s fancy new MongoDB-compatible DBMS really PostgreSQL under the covers? This blog post makes a pretty compelling argument that it is.
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.
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.
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.
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.
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.
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.
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.
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.
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.