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

From Jim Nasby
Subject Re: [HACKERS] Proposal : For Auto-Prewarm.
Date
Msg-id e2c75278-3e75-6c95-e4eb-34d5df1d2ac5@BlueTreble.com
Whole thread Raw
In response to Re: [HACKERS] Proposal : For Auto-Prewarm.  (Beena Emerson <memissemerson@gmail.com>)
Responses Re: [HACKERS] Proposal : For Auto-Prewarm.  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On 1/26/17 10:11 PM, Beena Emerson wrote:
> In that case, we could add the file location parameter.  By default it
> would store in the cluster directory else in the location provided. We
> can update this parameter in standby for it to access the file.

I don't see file location being as useful in this case. What would be 
more useful is being able to forcibly load blocks into shared buffers so 
that you didn't need to restart.

Hmm, it occurs to me that could be accomplished by providing an SRF that 
returned the contents of the current save file.

In any case, I strongly suggest focusing on the issues that have already 
been identified before trying to add more features.
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [HACKERS] increasing the default WAL segment size
Next
From: Corey Huinker
Date:
Subject: Re: \if, \elseif, \else, \endif (was Re: [HACKERS] PSQL commands:\quit_if, \quit_unless)