Meeting modern demand for enterprise data requires distributed high availability—running your database in multiple locations at once, so when one fails, the others keep serving traffic without interruption. That’s what...
When applications using multiple database access emerges, it is ready to apply this to PostgreSQL. Learn more in this blog post about deadlock detection spanning multiple databases.
Global deadlock is a phenomenon that current single databases cannot detect. This new blog series will provide information on what deadlock is, how it is handled currently in PostgreSQL, and...
In PostgreSQL 11, a new functionality of autoprewarm has been added into the contrib module pg_prewarm. This automatically warms the shared buffers with the same pages held before the last...
Unlike other database systems, Postgres makes the cleanup process visible and tunable to users. Autovacuum performs recycling of old rows and updates optimizer statistics. It appears in ps command output...
In my previous blog post about horizontal scalability changes in PostrgreSQL 9.6, I covered pushing sorts and joins to the remote server, but Robert Haas has just committed a change...
