Buy Percona ServicesBuy Now!

fork, exec, wait and exit

 | January 4, 2021 |  Posted In: DevOps, Entry Level, Information, Intermediate Level, Tools

This is the english version of a 2007 article. In de.comp.os.unix.linux.misc somebody asked: Are commands in a script executed strictly sequentially, that is, will the next command only be executed when the previous command has completed, or will the shell automatically start the next command if the system has spare capacity? Can I change the […]

Read More

Fixing Common PostgreSQL Performance Bottlenecks

 | December 4, 2020 |  Posted In: PostgreSQL

Overview In this article, I look at how poorly designed sharding systems and replication systems in PostgreSQL affect query performance in high volume situations, and how to ensure data consistency across many servers.  I also discuss how excessive vacuuming generates I/O traffic, and how connection pooling is used to improve transaction throughput by caching connections […]

Read More

How to build a high-performance application on Tarantool from scratch

 | October 30, 2020 |  Posted In: Advanced Level, DevOps, Open Source Databases, Tools

tarantool 3

I came to Mail.ru Group in 2013, and I required a queue for one task. First of all, I decided to check what the company had already got. They told me they had this Tarantool product, and I checked how it worked and decided that adding a queue broker to it could work perfectly well. […]

Read More