Tag - PostgreSQL

Percona Live 2017: Histograms in MySQL and MariaDB

Histograms

The afternoon at Percona Live 2017 is slipping by quickly, and people are still actively looking for sessions to attend – like the session I just sat in on histograms in MySQL and MariaDB.
Histograms are a type of column statistic that provides more detailed information about data distributions in table columns. A histogram sorts […]

Read more

Percona Live 2017: Designing your SaaS Database for Scale with Postgres

Postgres

The Percona Live Open Source Data Conference 2017 day one is rolling right along, and we’re already in the afternoon sessions. In this blog, we’ll look at Citus Data’s presentation on how to design your SaaS database to scale with Postgres.
If you’re building a SaaS application, you probably already have the notion of tenancy […]

Read more

Percona Live Featured Session with Ilya Kosmodemiansky: Linux IO internals for Database Administrators

Percona Live

Welcome to another post in the series of Percona Live featured session blogs! In these blogs, we’ll highlight some of the session speakers that will be at this year’s Percona Live conference. We’ll also discuss how these sessions can help you improve your database environment. Make sure to read to the end to get a special Percona […]

Read more

Open Source Databases on Big Machines: Disk Speed and innodb_io_capacity

In this blog post, I’ll look for the bottleneck that prevented the performance in my previous post from achieving better results.
The powerful machine I used in the tests in my previous post has a comparatively slow disk, and therefore I expected my tests would hit a point when I couldn’t increase performance further due to the disk speed.
Hardware […]

Read more

Percona Live Europe 2016: “PostgreSQL Worst Practices” with Ilya Kosmodemiansky

Percona Live Europe

Day one of Percona Live Europe 2016 is coming to a close, but the sessions keep coming. The afternoon contained just as many packed presentations as the morning, with the same enthusiastic transfer of knowledge.
In getting Percona Live Europe 2016 ready this year, something unexpected happened. We noticed the PostgreSQL community come together and […]

Read more