Re: Proposal : For Auto-Prewarm.

From: Mithun Cy <mithun(dot)cy(at)enterprisedb(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Cc: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Subject: Re: Proposal : For Auto-Prewarm.
Date: 2016-10-27 11:48:03
Message-ID: CAD__OuiHO2STqzO_p34BCgN1FBv7U2b2RfAOVb98zVF_iO3GoQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-hackers

On Thu, Oct 27, 2016 at 5:09 PM, Mithun Cy <mithun(dot)cy(at)enterprisedb(dot)com>
wrote:
> This a PostgreSQL contrib module which automatically dump all of the
blocknums
>present in buffer pool at the time of server shutdown(smart and fast mode
only,
>to be enhanced to dump at regular interval.) and load these blocks when
server restarts.

Sorry I forgot add warmup time performance measurement done based on this
patch. Adding now.
--
Thanks and Regards
Mithun C Y
EnterpriseDB: http://www.enterprisedb.com

Attachment Content-Type Size
pg_autoprewarm_perf_results.ods application/vnd.oasis.opendocument.spreadsheet 44.2 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Karl O. Pinc 2016-10-27 12:14:22 Re: Patch to implement pg_current_logfile() function
Previous Message Amit Kapila 2016-10-27 11:44:56 Re: Speed up Clog Access by increasing CLOG buffers