Robert Haas <robertmh...@gmail.com> wrote:
> Amit Kapila <amit.kapil...@gmail.com> wrote:
>> I have used pg_prewarm during some of work related to Buffer
>> Management and other performance related work. It is quite
>> useful utility.
>> +1 for reviving this patch for 9.4
> Any other votes?
Where I would have used a prewarm utility is following an off-hours
VACUUM FREEZE run. Where this maintenance made sense the only
downside I saw was a brief period in the mornings where the cache
was not populated with the "hot" data, and performance was somewhat
degraded until the cache settled in again.
The Enterprise PostgreSQL Company
Sent via pgsql-hackers mailing list (firstname.lastname@example.org)
To make changes to your subscription: