Linux IO internals for PostgreSQL administrators
Ilya Kosmodemiansky is an expert of Data Erget, specialist in database management systems PostgreSQL, DB2, Oracle. His area of professional interests covers issues of transactional data processing and fault-tolerant productive storage development. Ilya pays much attention to popularization of PostgreSQL technology among Russian-speaking audience. Regularly he holds lectures and workshops on effective use of PostgreSQL features in high-load web-, telecom- and related areas projects.
Input-output (IO) performance issues have been on DBAs’ agenda since the beginning of databases. The volume of data grows rapidly and time is of an essence when one needs to get necessary data fast from the disk and, more importantly, to the disk.
For most databases it is relatively easy to find checklist of recommended Linux settings to maximize IO throughput and, in most cases, this checklist is indeed good enough. It is however essential always to understand how the optimisation of those settings actually works, especially, if you run into corner cases.
Some fundamental differences in IO approaches between PostgreSQL, Oracle and MySQL will also be covered.