Overview This blog post summarizes key insights from a webinar, “Tuning Tips to Maximize Postgres Performance,” hosted by EDB. The webinar, featuring Dave Page, VP and Chief Architect of Database Infrastructure, and Devrim Gundus, an EDB consultant, offers a deep dive into optimizing Postgres performance, from hardware considerations to query tuning techniques. If you prefer … Read more
Overview In this post, I will walk you through the setup of your environment and data so you can start quickly. As in the series introduction, I said that we will use PostgreSQL. The quickest way to set up a PostgreSQL database instance is by using docker-compose. Setting up PostgreSQL using docker-compose You can use … Read more
Update 2025 Please check out the new client here that supports a wide range of PostgreSQL version: https://hub.docker.com/r/dattm24/postgresql-client if you want to customize, here is the repo: https://github.com/datmt/docker-clients/tree/main/postgresql-client Recently I had to write a bash script to truncate all tables on a test database server. Using PgAdmin is a real pain since I have a … Read more