The annual PGConf India conference just took place in Bengaluru on February 26-28, where EDB had seven of its experts speaking—including a keynote address by senior VP of product development...
Kubernetes (K8s) is increasingly gaining popularity. With the growing interest of containers/K8s, Postgres is also becoming a core technology that many developers/users want to deploy in the same environment. This...
This technical blog explains how CREATE INDEX CONCURRENTLY (CIC) works and how it manages to avoid locking the table from updates. A unique distinguishing factor of CIC is that it...
Part Three: PgBouncer and persistent connections during downtime (This is part three of my technical response to a series of questions about the use of PgBouncer and what you need...
Connection pooling is a big deal in Postgres. Connections to the database can take a relatively large amount of overhead, especially if there are a lot of them, and here...
The short answer is: it’s gone. With PostgreSQL v12, “recovery.conf” is no longer valid. Even if someone were to create a recovery.conf file manually and keep it under the data...
PostgreSQL 12 is focused on performance and optimization. This release wasn’t built with brand-new, shiny features in mind; instead, it’s a finely-tuned, well-polished implementation of existing PostgreSQL capabilities. Because new...
Docker is an open source platform where we can create, deploy, and run applications by using containers. Docker is similar to virtual machines (VM), but in VM you need to...
Protecting data across your enterprise is a tough job. Data centers are complex environments and are constantly changing to support business demands. As organizations expand their use of Postgres in...
Database connection poolers are useful tools that enable organizations to deliver high-performing applications by efficiently utilizing Postgres. Implementing a high-quality connection pooler is a frequent request of clients using Postgres...
