Tag - PostgreSQL

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

PostgreSQL Day at Percona Live Amsterdam 2016

PostgreSQL Day

Introducing PostgreSQL Day at Percona Live Europe, Amsterdam 2016.
As modern open source database deployments change, often including more than just a single open source database, Percona Live has also changed. We changed our model from being a purely MySQL-focused conference (with variants) to include a significant amount of MongoDB content. We’ve also expanded our […]

Read more

Django with time zone support and MySQL

This is yet another story of Django web-framework with time zone support and pain dealing with python datetimes and MySQL on the backend. In other words, offset-naive vs offset-aware datetimes.
Shortly, more about the problem. After reading the official documentation about the time zones, it makes clear that in order to reflect python datetime […]

Read more