Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Proposal : For Auto-Prewarm. - Mailing list pgsql-hackers

From Beena Emerson
Subject Re: [HACKERS] Proposal : For Auto-Prewarm.
Date
Msg-id CAOG9ApGM=baCUcQ+wbr7=5bPYdysfrkrQUvtBcY2i3QPS5q0Eg@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Proposal : For Auto-Prewarm.  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Responses Re: [HACKERS] Proposal : For Auto-Prewarm.  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-hackers
Tree view


On Wed, Jan 25, 2017 at 10:36 AM, Jim Nasby <Jim.Nasby@bluetreble.com> wrote:
On 1/24/17 2:26 AM, Mithun Cy wrote:
Thanks for looking into this patch, I just downloaded the patch and
applied same to the latest code, I can see file " autoprewarm.save" in
$PGDATA which is created and dumped at shutdown time and an activity
is logged as below
2017-01-24 13:22:25.012 IST [91755] LOG:  Buffer Dump: saved metadata
of 59 blocks.

 Yeah, I wasn't getting that at all, though I did see the shared library being loaded. If I get a chance I'll try it again.


Hope u added the following to the conf file:

shared_preload_libraries = 'pg_autoprewarm'     # (change requires restart)
pg_autoprewarm.buff_dump_interval=20

Even after this u could not see the message then that's strange.
 
--
Thank you, 

Beena Emerson

Have a Great Day!

pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: [HACKERS] Proposal : For Auto-Prewarm.
Next
From: Michael Paquier
Date:
Subject: Re: [HACKERS] Assignment of valid collation for SET operations onqueries with UNKNOWN types.