Improving Postgres' concurrency

Доклад, 17 июля

Improving Postgres' concurrency pdf Скачать

Postgres has for a long time been lauded to handle concurrency well, being able to process more requests if additional resources (CPUs) are added. Unfortunately, after that had been determined many years ago, not much work had been put into the topic. But since then the number of cores and the general architecture of parallel systems have changed, which to led to the situation when we don't scale as well as we'd like.<br /> <br /> I'll talk about recent changes to scalability (9.2, 9.5) that improved things considerably and what the biggest remaining scalability concerns are. Some of the remaining issues can mainly be addressed by changing<br /> Postgres, others can be worked around on the application side.