Michael is a freelance database consultant, back-end data engineer and founder of technical writing firm @BytesDaten. He is based in Accra, Ghana and has worked with startups in the eCommerce and healthcare industry. His tech stack includes but not limited to Kafka, Hadoop, Storm, Python, Rails, Cassandra, Postgres, Elastic Search, Redis and Zookeeper. Follow him on twitter @kwaku_mikey
Fixing Common PostgreSQL Performance Bottlenecks
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 from clients. I also cover how insufficient memory could affect PostgreSQL performance. These are key problems I have encountered as a database consultant, and how I’ve overcome them.
Read more »