UUIDs are popular, but bad for performance (2019)
MySQL UUIDs are still very popular despite a majority of posts warning against their usage. Learn what UUIDs are and why they are very bad for MySQL performance.
Enterprise-class open source database software, support and services for MySQL, PostgreSQL, MongoDB, Redis and MariaDB.
Visit percona.com → RSS feedOn Hacker News Nov 2017 – Aug 2022
Databases & Data 11Systems & Performance 7Software Engineering 5Infrastructure & DevOps 1
MySQL UUIDs are still very popular despite a majority of posts warning against their usage. Learn what UUIDs are and why they are very bad for MySQL performance.
Parallelism in PostgreSQL was implemented as part of multiple features which cover sequential scans, aggregates, and joins.
Choosing between MariaDB and MySQL? In this blog, we provide an overview of the key differences between MariaDB vs. MySQL and explore their unique use cases.
Yes, the stats collector is gone from PostgreSQL 15, but there's lots of new exciting features to talk about!
Percona has developed a new pg_stat_monitor plugin for PostgreSQL which captures all the details in order to provide deep query performance insights.