Re:PostgreSQL 9.4 Beta 1 Released
by corford on Thursday May 15, 2014 @11:13AM
(#7749886)
pg_prewarm looks interesting but the docs are currently a little opaque as to how best to use it (for me at least!): http://www.postgresql.org/docs/devel/static/pgprewarm.html
[ Parent
| on HN ]
Oh, is it now a built-in module in 9.4beta?
I've used it in 9.1 (downloading the patch, applying it, recompiling postgres..) - have found this article re: postgres caching mechanisms (and pg_prewarm use in particular (though re: pg_prewarm, most of it is about applying the patch itself, etc.)) useful:
http://raghavt.blogspot.com/2012/04/caching-in-postgresql.ht...
P.S. here are some more comments from the author: http://www.postgresql.org/message-id/CA+TgmoZihvzFW6n6pPwzDO... (btw, I've found the pgsql-hackers to be a great mailing list indeed!)
Thanks wfn, those links are really helpful.