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