On Tue, Sep 4, 2018 at 3:16 AM jimmy <mpokky@xxxxxxx> wrote:
On windows, how to put an entry in my db startup script to run this query （pg_prewarm） immediately after startng the server, and let the query warm the cache itself.
Starting with PostgreSQL version 11 (to be released soon), you can use pg_prewarm.autoprewarm.
Until then, maybe this: https://superuser.com/questions/502160/run-a-scheduled-task-after-a-windows-service-is-started
I've tested neither one.
Cheers,
Jeff
