Announcing Connection Pooling for Postgres Databases

Sam Aybar
Jan 11, 2024
Share:

PolyScale.ai is pleased to announce the release of Connection Pooling for Postgres databases. Any customers using Postgres databases can now enable TCP based connection pooling with their PolyScale cache. With pooling enabled, customers can reduce the number of TCP connections made to the origin database while also dramatically reducing the time to establish new connections.

swimmingpool blog preview
PolyScale Pooling for Postgres

PolyScale is an AI-driven, distributed cache for Postgres, MySQL, MariaDB, MS SQL and MongoDB. Using smart caching and a global Data Delivery Network (DDN), it reduces database load, improves query performance and lowers network latency both on premise and at the edge.

PolyScale already offers connection pooling for MySQL, MS SQL and MariaDB (both TCP and HTTP). Connection pooling for Postgres is one of the most requested features from our customers. We are excited to add this capability and help people get the most from their Postgres databases.

The addition of Pooling for Postgres brings the following benefits:

  • Lower connection latency - PolyScale’s PoP’s can be geographically closer to the client
  • Lower connection latency - the auth handshake process is cached by PolyScale
  • Low query execution time - PolyScale will serve a cache hits sub-ms.
  • Higher connection count - Very high numbers of connections can be established without impacting the origin database

Next Steps

Pooling can be enabled for Postgres databases with PolyScale from the Settings tab of the cache dashboard. Whilst in a Beta phase, there is no charge associated with pooling usage. Pricing will be announced shortly.

Read how to set up a Postgres cache or see the full documentation about Postgres pooling.

Share:
Written by

Sam Aybar