Improving Postgres Performance Tenfold Using Go Concurrency

Description

Summary

• In this article I will show how Go concurrency enabled us to cut through a daunting DB performance barrier.
• We need to create a traffic cop that will put them in line without an interface change.
• You may create the table using just two sql statements from this sql file The test driver I wrote a test driver that generates 3 million random keys, and sends them via a channel to three hundred reading goroutine instances(tunable by constant) that perform the reads.
• In a future post, we will discuss more ways in which we made Postgres pull the throughput and response time required in a big data environment.