mithuncy's picture
Author: Mithun Chicklore Yogendra
09/25/2018

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 server restart. To accomplish this, Postgres now has a background worker to periodically record the contents of the shared buffers in the file -- “autoprewarm.blocks”. Next, it will reload those pages after the server restart.

 

Now, that we know the basic functionality of autoprewarm, let's dive into the details of how to use this feature. Continue reading on PostgresRocks to learn more. >>

 

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.