Looking at MySQL 8 with PostgreSQL goggles on
Compare MySQL 8 and PostgreSQL for available features, general querying experience and documentation clarity.
Major feature update for the pgwatch2 Postgres monitoring tool
Feature Pack 4 of the PostgreSQL monitoring tool pgwatch2 is out. This article gives an overview about the new features and improvements.
Unearthing some hidden PostgreSQL 11 gems
Kaarel has a look on interesting/useful little features and improvements of PostgreSQL 11. Add column pg_stat_activity.backend_type and more.
PostgreSQL affiliate projects for horizontal multi-terabyte scaling
Don’t be afraid to scale up with Postgres: Overview about PostgreSQL extensions and derivatives for horizontal multi-terabyte scaling.
Machine Learning in PostgreSQL Part 1: Kmeans clustering
Let's take a look at how to do Kmeans, one of the most popular unsupervised learning algorithms, directly within PostgreSQL using PLPython.
Query performance of the upcoming version 11 of PostgreSQL
Release notes of first RC of PostgreSQL 11 didn't state any numerical query performance indicators, so we have to find it out on our own.
Ideas for scaling PostgreSQL to multi-terabyte and beyond
Features and "hacks" for scaling PostgreSQL to multi-terabyte and beyond. Ways to safely accommodate decent multi-terabyte size databases.
Next feature release for the pgwatch2 monitoring tool
New features for the pgwatch2 PostgreSQL monitoring tool, including Ansible, sharding and developer mode support.
More on Postgres trigger performance
A performance test on more complex Postgres trigger usage scenarios, together with some extra info on trigger capabilities.
Are triggers really that slow in Postgres?
PostgreSQL trigger performance. Should we use tiggers at all? Find out how triggers perform in performance tests.
