PostgreSQL for Beginners - Demos on pgbouncer

[@farooqahmedsiddiqui7859]

Thank you very much, the video is very much helpful.. you have done marvelous efforts, please keep it up and regards.

[@karnanytcodm2715]

thank you for your guidance sir, I learned and implemented successfully. Now its working fine. thanks a lot 👌👌😎😎😍😍👍👍

[@mohammedrai8197]

Thanks for the sharing, and the simplicity and quality of the explanation.
Waiting for demo on tuning and tracking performances of PostgreSQL database.

[@thefatdba]

beautifully explained. Good work!

[@rajasekhar320]

Awsome talent and explaination

[@busylearner8072]

Thank you

[@seshubalu123]

Excellent explanation

[@busylearner8072]

Thank you

[@priyankpanchal5232]

thanks for a great tutorial

[@veerareddy6723]

Thank you. It is very helpful. Can I configure primary and standby in the same pgbouncer configuration or need to install pgbouncer in standby also.

[@busylearner8072]

Yes as long as you connectivity.

[@tamsan1000]

Sooper sir 👍

[@busylearner8072]

Thank you Tamil

[@AMOLPALAV44]

very informative session, thank you so much.
Just 1 question....
if we use connection pooling then as connection re-establish time gets saved so in your demo 1 why pgbench sessions running with port 5432 (no pooling) completed faster than 6432.

[@busylearner8072]

Hi Amol,
Thank you. Let me review and will comeback soon,

[@busylearner8072]

Thanks once again Amol.
Let me explain your query here.
Q) pgbench response time with out using pgbouncer - port : 5432 is less comparatively pgbench response time with using pgbouncer - port : 6432.
Ans) For Demo purpose I had setup two server. One is DB server and pgbouncer server.
I ran pgbench utility in DB server.
With port 5432: the request travelling path was "DB Server (pgbouncer) --> DB server (DB) --> DB Server (pgbouncer)". In real time scenario the connections will be initiated from Web/ Application servers.
Whereas With port 6432: the request travelling path was "DB Server (pgbouncer) --> PG bouncer Server --> DB server (DB) --> PG bouncer Server --> DB Server (pgbouncer)".
I believe, I have answered you question. Please let me know if you have any further query on this.

[@AMOLPALAV44]

@@busylearner8072 got it, thank you so much for the detailed explanation, really helpful.
Can you please tell me where can I get the material used for the test case, I want to try it by myself.

[@busylearner8072]

Hi Amol,
For all of my videos I am preparing demos on my own.
I have gone through multiple websites to understand the concepts.
If at all if I get any reference link in future I will post it to you.
- Kiran

[@AMOLPALAV44]

ty Kiran, much appreciated.

[@ijhquliyev3325]

hi my dear, can you help me. I have created pgbench as you show you in this video. But, when i am trying to connect with pgbench it gives me an error: password authentication failed. What do you think about such issue?

[@busylearner8072]

Hi, 1. Check the password
2. Check the entries in pg_hba.conf

[@mohammedrai8197]

Can you make a demo tutorial on Setting up PgBouncer and Postgersql with SSL certificate and scram-sha-256 authentications

[@busylearner8072]

Thanks for your comments. Will do the demo and will share

[@pavankumar-jy3tf]

how to install pgbouncer in windows

[@vishalamirt]

Wonderful explanation

[@busylearner8072]

Thank you