Presented by:


Grant Zhou

Highgo Software

Grant currently lived in Canada, he is the founder of Highgo Software branches in North America, which are R&D branches of Highgo Software. He worked in Alcatel-Lucent (Nokia) company for more than ten years and had rich experiences on high availability and real-time telecommunication systems. He is working as the director of China PostgreSQL Association, and the secretary of the International Consultant Committee of the association at the same time.

Muhammad Usama is a database architect / PostgreSQL consultant at HighGo Software and also Pgpool-II core committer. Usama has been involved with database development (PostgreSQL) since 2006, he is the core committer for open source middleware project Pgpool-II and has played a pivotal role in driving and enhancing the product. Prior to coming to open source development, Usama was doing software design and development with the main focus on system-level embedded development. After joining the EnterpriseDB, an Enterprise PostgreSQL’s company in 2006 he started his career in open source development specifically in PostgreSQL and Pgpool-II. He is a major contributor to the Pgpool-II project and has contributed to many performance and high availability related features.

No video of the event yet, sorry!

Pgpool II performance and best practises Online training Middleware can have a significant impact on the operation and performance of the database system. Pgpool-II is the middleware product that sits between the PostgreSQL server and database clients and is developed and maintained by a committed open source Postgres community that includes HighGo employees. The most widely used features in Pgpool-II are connection pooling, statement level load balancing, replication and a high availability (HA) feature known as watchdog, which provides automatic failover between pgpool instances. The newest version of Pgpool-II v4.1, beta for pgpool II 4.1 was released recently. Pgpool is almost as old as PostgreSQL itself, and often when somebody was talking about PostgreSQL cluster, they were referring to PostgreSQL behind Pgpool and not to the PostgreSQL instance itself. Although the name may suggest as if Pgpool is just a connection pooling solution, but in actual Pgpool is a lot more than just a pooler and provides so many amazing features especially when it comes we require scalability and high availability of a PostgreSQL

The tutorial aims to provide the overview and best practices of using Pgpool-II. Join this tutotial to find out the exciting features added in pgpool II in last set of major releases. One of the main goal of pgpool II is to provide performance with read scalability, find out how to setup and configure pgpool II optimally to get he best performance. Tentative schedule: Introduction Overview of Pgpool-II and where it fits in. Options and features of Pgpool-II Load balancing and performance expectations High availability Pgpool-II in cloud How to get best performance out of pgpool II pgpool II features in last few major releases How to setup and configure pgpool II Trouble shooting with pgpool.

3 h 30 min
Postgres Digital Training Series
Requires Registration:
Yes (Registered: 1/40)