News for hackers. Stuff that matters.
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
Re:PostgreSQL 9.4 Beta 1 Released by wfn on Thursday May 15, 2014 @01:05PM (#7750738)
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!)

Re:PostgreSQL 9.4 Beta 1 Released by corford on Thursday May 15, 2014 @01:17PM (#7750820)
Thanks wfn, those links are really helpful.
Re:PostgreSQL 9.4 Beta 1 Released by alternize on Thursday May 15, 2014 @02:29PM (#7751281)
very interesting indeed, thanks for the pointer