{"id":4361,"date":"2023-08-30T05:29:59","date_gmt":"2023-08-30T05:29:59","guid":{"rendered":"https:\/\/test.opensource-db.in\/wp1\/?p=4361"},"modified":"2023-08-30T06:40:30","modified_gmt":"2023-08-30T06:40:30","slug":"pgcat-connection-pooling-decoded-part-1","status":"publish","type":"post","link":"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/","title":{"rendered":"PgCat – Connection Pooling Decoded – Part 1"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\n

Introduction<\/strong><\/h2>\n\n\n\n

PostgreSQL – The World’s Most Advanced Open Source Relational Database <\/strong>holds its ground as a formidable player in the Open-source Databases market. With respect to Connection scalability & Connection concentration layers, optimising connection pooling, load balancing, and replica failover presents significant challenges. To address these complexities, a novel solution has emerged – PgCat, an open-source PostgreSQL proxy.<\/p>\n\n\n\n

Introducing PgCat<\/strong>: An All-in-One PostgreSQL Connection Pooling software<\/p>\n\n\n\n

PgCat. Think of it as a versatile helper for PostgreSQL developed in Rust – a programming language that emphasizes performance, type safety, and concurrency. It’s not just about managing connections\u2014it’s a whole package that takes care of connection pooling, load balancing, and making sure everything runs smoothly, even when replicas hiccups.<\/p>\n\n\n\n

The PgCat Advantage<\/strong><\/h2>\n\n\n\n

Efficient Resource Utilisation<\/strong>: PgCat smartly manages a pool of established connections, ensuring that resources are not exhausted by repeatedly opening and closing connections.<\/p>\n\n\n\n

Enhanced Performance<\/strong>: By reusing connections, PgCat minimizes the time spent on setting up new connections, resulting in improved response times and reduced latency.<\/p>\n\n\n\n

Connection Multiplexing<\/strong>: PgCat allows multiple applications to share a single connection, effectively reducing the overall number of connections and saving resources.<\/p>\n\n\n\n

Load Balancing<\/strong>: PgCat seamlessly distributes incoming connections across multiple PostgreSQL servers, preventing bottlenecks and optimizing workload distribution.<\/p>\n\n\n\n

Idle Connection Management<\/strong>: PgCat monitors idle connections and reclaims them if they remain unused for a specified period, preventing connection leaks and freeing up resources.<\/p>\n\n\n\n

Failover and High Availability<\/strong>:  PgCat supports failover scenarios, automatically redirecting connections to a standby server in case the primary server fails, ensuring uninterrupted service.<\/p>\n\n\n\n

Configuration Flexibility<\/strong>: PgCat provides customizable configurations to fine-tune connection pooling based on your application’s unique requirements.<\/p>\n\n\n\n

While PgBouncer and PgPool-II offer connection pooling and some related features, PgCat aims to provide a more comprehensive and sophisticated solution. Its focus on enhanced connection management, load balancing, failover support, configuration flexibility, and seamless integration makes it a compelling option for optimising PostgreSQL environments. Here\u2019s a quick summary of the features offered by PgCat in comparison to it’s predecessors <\/p>\n\n\n\n

Features<\/strong><\/td>PgCat<\/strong><\/td>PgBouncer<\/strong><\/td>PgPool-II<\/strong><\/td><\/tr>
Load Balancing<\/em><\/td>Yes<\/em><\/strong><\/td>Limited<\/em><\/td><\/em> Yes<\/em><\/td><\/tr>
Replica Failover<\/em><\/td><\/em><\/strong> Yes<\/em><\/strong><\/td>No<\/em><\/td><\/em> Yes<\/em><\/td><\/tr>
Language Support<\/em><\/td>All<\/em><\/strong><\/td>Specific<\/em><\/td>All<\/em><\/td><\/tr>
Transaction Pooling<\/em><\/td><\/em><\/strong> Yes<\/em><\/strong><\/td>No<\/em><\/td><\/em> Yes<\/em><\/td><\/tr>
Statement Pooling<\/em><\/td><\/em><\/strong> No<\/em><\/strong><\/td>Yes<\/em><\/td><\/em> Yes<\/em><\/td><\/tr>
Connection Limits<\/em><\/td>Dynamic<\/em><\/strong><\/td>Fixed<\/em><\/td>Fixed<\/em><\/td><\/tr>
Sharding Support<\/em><\/td><\/em><\/strong> Yes<\/em><\/strong><\/td>No<\/em><\/td><\/em> Yes<\/em><\/td><\/tr>
Multi-Threaded<\/em><\/td><\/em><\/strong> Yes<\/em><\/strong><\/td>No<\/em><\/td><\/em> Yes<\/em><\/td><\/tr>
Load Balancing Algos<\/em><\/td>Random, Least Connections<\/em><\/strong><\/td>Round Robin<\/em><\/td>Round Robin, Weighted<\/em><\/td><\/tr>
Control Commands<\/em><\/td><\/em><\/strong> Yes<\/em><\/strong><\/td><\/em> Yes<\/em><\/td><\/em> Yes<\/em><\/td><\/tr>
Security<\/em><\/td>SSL\/TLS<\/em><\/strong><\/td>Basic Auth<\/em><\/td>SSL\/TLS, Kerberos<\/em><\/td><\/tr>
Session Tracking<\/em><\/td><\/em><\/strong> Yes<\/em><\/strong><\/td>No<\/em><\/td>Yes<\/em><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Architectural changes<\/strong><\/h2>\n\n\n\n

The distinct architectural feature of PgCat is its multi-threaded design, distinguishing it from the single-threaded nature of PgBouncer. Its deployment configurations, capacity to accommodate multiple users and pools, and utilisation of advanced load-balancing algorithms (random and least connections) provide administrators with an exceptional level of flexibility.<\/p>\n\n\n\n

Sharding and Beyond: Expanding Horizons<\/strong><\/h2>\n\n\n\n

Highlighting its adaptability, PgCat seamlessly handles sharded databases. This empowers applications to select particular shards using sharding keys or numbers\u2014a crucial advantage for complex configurations.<\/p>\n\n\n\n

A logical culmination:<\/strong><\/h2>\n\n\n\n

We’ve found a reliable companion in PgCat, that effortlessly meets our needs for connection management, load distribution, and replica recovery. With its smart Rust-based design, impressive features, and knack for handling many tasks at once, PgCat has transformed the way we manage PostgreSQL.<\/p>\n\n\n\n

Anticipate a Remarkable Shift: Brace yourself for Part 2, as exciting revelations await in the next installment of our blog series. In the upcoming segment, we will delve into the practical aspects, delving into the implementation intricacies and unraveling the pivotal parameters that ensure a seamless transition from non-PgCat to the PgCat environment.<\/p>\n\n\n\n

Stay tuned…..<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

Introduction PostgreSQL – The World’s Most Advanced Open Source Relational Database holds its ground as a formidable player in the […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[65,23,42],"tags":[84,26],"class_list":["post-4361","post","type-post","status-publish","format-standard","hentry","category-pgbouncer","category-postgresql-14","category-postgresql-15","tag-connection-pooling","tag-postgresql"],"yoast_head":"\nPgCat - Connection Pooling Decoded - Part 1 - OpenSource DB<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PgCat - Connection Pooling Decoded - Part 1 - OpenSource DB\" \/>\n<meta property=\"og:description\" content=\"Introduction PostgreSQL – The World’s Most Advanced Open Source Relational Database holds its ground as a formidable player in the […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/\" \/>\n<meta property=\"og:site_name\" content=\"OpenSource DB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-30T05:29:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-30T06:40:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/08\/blog-pgcat-1024x538.png\" \/>\n<meta name=\"author\" content=\"Taraka Vuyyuru\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@opensource_db\" \/>\n<meta name=\"twitter:site\" content=\"@opensource_db\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Taraka Vuyyuru\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/\"},\"author\":{\"name\":\"Taraka Vuyyuru\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/55546e9ca9552218b9376d4ecc8447a5\"},\"headline\":\"PgCat – Connection Pooling Decoded – Part 1\",\"datePublished\":\"2023-08-30T05:29:59+00:00\",\"dateModified\":\"2023-08-30T06:40:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/\"},\"wordCount\":611,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/08\/blog-pgcat-1024x538.png\",\"keywords\":[\"connection-pooling\",\"postgresql\"],\"articleSection\":[\"PgBouncer\",\"PostgreSQL 14\",\"PostgreSQL 15\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/\",\"name\":\"PgCat - Connection Pooling Decoded - Part 1 - OpenSource DB\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/08\/blog-pgcat-1024x538.png\",\"datePublished\":\"2023-08-30T05:29:59+00:00\",\"dateModified\":\"2023-08-30T06:40:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/#primaryimage\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/08\/blog-pgcat.png\",\"contentUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/08\/blog-pgcat.png\",\"width\":1800,\"height\":945},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/test.opensource-db.in\/wp1\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PgCat – Connection Pooling Decoded – Part 1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#website\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/\",\"name\":\"OpenSource DB\",\"description\":\"Your Trusted OpenSource Databases partner\",\"publisher\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/test.opensource-db.in\/wp1\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\",\"name\":\"OPENSOURCE DB PRIVATE LIMITED\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png\",\"contentUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png\",\"width\":368,\"height\":120,\"caption\":\"OPENSOURCE DB PRIVATE LIMITED\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/\",\"https:\/\/x.com\/opensource_db\",\"https:\/\/www.youtube.com\/channel\/UCmTI5h\",\"https:\/\/www.linkedin.com\/company\/opensource-db\",\"https:\/\/www.instagram.com\/opensource_db\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/55546e9ca9552218b9376d4ecc8447a5\",\"name\":\"Taraka Vuyyuru\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/54256c344d6c1f7dbb87fa257d6e318d1ddcd0a29320b642116bfa20e693616b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/54256c344d6c1f7dbb87fa257d6e318d1ddcd0a29320b642116bfa20e693616b?s=96&d=mm&r=g\",\"caption\":\"Taraka Vuyyuru\"},\"url\":\"https:\/\/test.opensource-db.in\/wp1\/author\/taraka\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PgCat - Connection Pooling Decoded - Part 1 - OpenSource DB","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"PgCat - Connection Pooling Decoded - Part 1 - OpenSource DB","og_description":"Introduction PostgreSQL – The World’s Most Advanced Open Source Relational Database holds its ground as a formidable player in the […]","og_url":"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/","og_site_name":"OpenSource DB","article_publisher":"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/","article_published_time":"2023-08-30T05:29:59+00:00","article_modified_time":"2023-08-30T06:40:30+00:00","og_image":[{"url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/08\/blog-pgcat-1024x538.png","type":"","width":"","height":""}],"author":"Taraka Vuyyuru","twitter_card":"summary_large_image","twitter_creator":"@opensource_db","twitter_site":"@opensource_db","twitter_misc":{"Written by":"Taraka Vuyyuru","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/#article","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/"},"author":{"name":"Taraka Vuyyuru","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/55546e9ca9552218b9376d4ecc8447a5"},"headline":"PgCat – Connection Pooling Decoded – Part 1","datePublished":"2023-08-30T05:29:59+00:00","dateModified":"2023-08-30T06:40:30+00:00","mainEntityOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/"},"wordCount":611,"commentCount":0,"publisher":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#organization"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/08\/blog-pgcat-1024x538.png","keywords":["connection-pooling","postgresql"],"articleSection":["PgBouncer","PostgreSQL 14","PostgreSQL 15"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/","url":"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/","name":"PgCat - Connection Pooling Decoded - Part 1 - OpenSource DB","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#website"},"primaryImageOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/#primaryimage"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/08\/blog-pgcat-1024x538.png","datePublished":"2023-08-30T05:29:59+00:00","dateModified":"2023-08-30T06:40:30+00:00","breadcrumb":{"@id":"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/#primaryimage","url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/08\/blog-pgcat.png","contentUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/08\/blog-pgcat.png","width":1800,"height":945},{"@type":"BreadcrumbList","@id":"https:\/\/test.opensource-db.in\/wp1\/pgcat-connection-pooling-decoded-part-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/test.opensource-db.in\/wp1\/"},{"@type":"ListItem","position":2,"name":"PgCat – Connection Pooling Decoded – Part 1"}]},{"@type":"WebSite","@id":"https:\/\/test.opensource-db.in\/wp1\/#website","url":"https:\/\/test.opensource-db.in\/wp1\/","name":"OpenSource DB","description":"Your Trusted OpenSource Databases partner","publisher":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/test.opensource-db.in\/wp1\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/test.opensource-db.in\/wp1\/#organization","name":"OPENSOURCE DB PRIVATE LIMITED","url":"https:\/\/test.opensource-db.in\/wp1\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/","url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png","contentUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png","width":368,"height":120,"caption":"OPENSOURCE DB PRIVATE LIMITED"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/","https:\/\/x.com\/opensource_db","https:\/\/www.youtube.com\/channel\/UCmTI5h","https:\/\/www.linkedin.com\/company\/opensource-db","https:\/\/www.instagram.com\/opensource_db\/"]},{"@type":"Person","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/55546e9ca9552218b9376d4ecc8447a5","name":"Taraka Vuyyuru","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/54256c344d6c1f7dbb87fa257d6e318d1ddcd0a29320b642116bfa20e693616b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/54256c344d6c1f7dbb87fa257d6e318d1ddcd0a29320b642116bfa20e693616b?s=96&d=mm&r=g","caption":"Taraka Vuyyuru"},"url":"https:\/\/test.opensource-db.in\/wp1\/author\/taraka\/"}]}},"rttpg_featured_image_url":null,"rttpg_author":{"display_name":"Taraka Vuyyuru","author_link":"https:\/\/test.opensource-db.in\/wp1\/author\/taraka\/"},"rttpg_comment":1,"rttpg_category":"<a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/extensions\/pgbouncer\/\" rel=\"category tag\">PgBouncer<\/a> <a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-14\/\" rel=\"category tag\">PostgreSQL 14<\/a> <a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-15\/\" rel=\"category tag\">PostgreSQL 15<\/a>","rttpg_excerpt":"Introduction PostgreSQL – The World’s Most Advanced Open Source Relational Database holds its ground as a formidable player in the […]","_links":{"self":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/4361","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/comments?post=4361"}],"version-history":[{"count":7,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/4361\/revisions"}],"predecessor-version":[{"id":4373,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/4361\/revisions\/4373"}],"wp:attachment":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/media?parent=4361"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/categories?post=4361"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/tags?post=4361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}