PgBadger is a PostgreSQL log analyzer with fully detailed reports and graphs. It is open source and is considered lightweight. While it doesn’t have the depth, probe capability or tool integration that EDB Postgres Enterprise Manager does, it’s particularly useful in helping you to analyze your slowest queries, and also does a good job of profiling Temporary Files, Connection Peak, Autovacuum/Autoanalyze, Checkpoints, etc which can help in demonstrating overall health of the database. In...

A corruption in the database base often manifests itself in the form of errors when performing a DDL or DML operation on affected relations. The errors often show up as errors reading tables due to a missing file—that is rather straightforward, of course. However, a corrupt index is not as obvious as a corrupt table. More often than not to find if indeed there is index corruption, one needs to observe the behavior (execution times) and results of the queries themselves. In this episode, we...

When it comes to dealing with poor database and query performance, it’s a daunting task to venture into the dark cavern of query planning and optimization, but fear not! EXPLAIN is our friend in those dark and lonely places. This session covers EXPLAIN and how it is certainly one of the most invaluable tools for anyone working with PostgreSQL. Using it well will save you lots of time! For more information on this topic, visit this blog: ...

Planning is key to PostgreSQL backup and recovery. Every environment has its own challenge—and even if we have multiple database clusters in the same organizations, the backup requirements for those might also vary. Therefore, it is important to list down the situations we might need to recover from and then discuss the possible solutions available. In this session, we discuss PostgreSQL backup woes, successes, and strategies. To learn more about this topic, visit this blog: ...

With the ongoing crisis of COVID-19, I keep myself updated with the latest situation around the globe. The WHO’s website is one I’ve used frequently—and even there I began to intermittently see the error message “sorry, too many clients already“ in my browser. In seeing this, I realized how common it is to underestimate the connection count while we are busy configuring the application. The above is a scenario we may all face today in our daily lives where a connection load problem may...

Most DBAs have run into issues where users can't access the database and alert that the database may be down. In this case, when DBAs dive into the issue, they find out that the database is up - just not for everyone. One common cause of these problems is an authentication error. In this video, we will dive into PostgreSQL LDAP authentication problems and how to fix them. For more details, take a look at this blog post: ...

Identifying exactly what causes a slow Postgres database and then optimizing PostgreSQL performance is the most important task for DBAs. One of the most widespread issues we see hit almost every database from time to time is poor performance. Database administrators are often bombarded by end-users with complaints about the database being slow. You’re expected to act quickly in order to diagnose and fix the problem. In this video, our Postgres experts dive into this issue and provide...

We get numerous tech issues and common database symptoms flagged to our team on a daily basis. And given the current landscape fraught with uncertainty, these, along with many new and pressing questions, are filing in at greater volumes. Now is the right time to use what we know to help you in your Postgres experience. Introducing: Postgres Pulse, a weekly blog and live video forum series built to offer insight into how we analyze problems and develop solutions using Postgres. Our Postgres...