On Friday, May 07th, 2021 Erik Brandsberg of Heimdall Data, a company which is based in Newark, CA USA, delivered the presentation entitled: “Scaling Beyond PostgreSQL PgBouncer and Postgres Pgpool-II: Advanced Traffic Management” — the description follows below.

Database proxies intelligently manage database connections to improve performance and scalability and can be an important component for any non-trivial software engineering effort.

In this session, we will highlight deficiencies of open-source PgBouncer and Pgpool-II that users should know, and propose solutions.

Scaling Postgres features to be discussed

The following list covers some of the topics that were discussed in this presentation and which are important when it comes to scaling the Postgres relational database:

  • PostgreSQL connection pooling

  • Postgres read/write splitting with Strong Consistency

  • PostgreSQL query caching

  • Persisted connection and automatic failover

  • Active Directory / LDAP integration

This Heimdall Data Technical Session presentation includes a live demo and Q&A section and is delivered by Erik Brandsberg, Chief Technical Officer of Heimdall Data.

author avatar
ThosPFuller
I am a software engineer based in Northern Virginia (USA) and this website focuses on content engineering, web development, Technical SEO, Search Engine Optimization (SEO).

Leave a Reply