Contributed by Richard Yen
Anyone running a database in a production environment with over a hundred users should seriously consider employing a connection pooler to keep resource usage under control. PgBouncer is one such tool, and it’s great because it’s lightweight and yet has a handful of nifty features for DBAs that have very specific needs. One of these nifty features that I want to share about is theauth_userandauth_querycombo that serves as an alternative to the default authentication process that usesuserlist.txt
“What’s wrong withuserlist.txt” you may ask?
Read more on Postgres Rocks to learn why user/role administration can be tricky. >>
Every #TechTuesday, EnterpriseDB shares a how-to post authored by a Postgres contributor and expert for Postgres Gems, the PostgresRocks community forum. PostgresRocks is a community to discuss all things Postgres. Join us at PostgresRocks and be part of the conversation.
Relevant Blogs
Autovacuum Tuning Basics
A few weeks ago I covered the basics of tuning checkpoints, and in that post I also mentioned autovacuum as the second common source of performance issues (based on what...