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

From Mithun Cy
Subject Re: [HACKERS] Proposal : For Auto-Prewarm.
Date
Msg-id CAD__Oui76TJr-iVhgTd7RAbeSARPeQePgSPiPV93en+hQEJyOg@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.  (Beena Emerson <memissemerson@gmail.com>)
Re: [HACKERS] Proposal : For Auto-Prewarm.  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Re: [HACKERS] Proposal : For Auto-Prewarm.  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
On Tue, Jan 24, 2017 at 5:07 AM, Jim Nasby <Jim.Nasby@bluetreble.com> wrote:
> I took a look at this again, and it doesn't appear to be working for me. The library is being loaded during startup,
butI don't see any further activity in the log, and I don't see an autoprewarm file in $PGDATA.
 

Hi Jim,
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.

In my code by default, we only dump at shutdown time. If we want to
dump at regular interval then we need to set the GUC
pg_autoprewarm.buff_dump_interval to > 0. I think I am missing
something while trying to recreate the bug reported above. Can you
please let me know what exactly you mean by the library is not
working.

> There needs to be some kind of documentation change as part of this patch.
Thanks, I will add a sgml for same.

For remaining suggestions, I will try to address in my next patch
based on its feasibility.


-- 
Thanks and Regards
Mithun C Y
EnterpriseDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: [HACKERS] Failure in commit_ts tap tests
Next
From: Craig Ringer
Date:
Subject: Re: [HACKERS] WIP: About CMake v2