Horton

Re: pg_prewarm

Joshua D. Drake <jd@commandprompt.com>

View thread
From: Joshua Drake <jd@commandprompt.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-hackers@postgresql.org
Date: 2012-03-09T08:52:28Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. pgstattuple: Use a BufferAccessStrategy object to avoid cache-trashing.

So I wrote a prewarming utility. Patch is attached. You can prewarm 
either the OS cache or PostgreSQL's cache, and there are two options for 
prewarming the OS cache to meet different needs. By passing the correct 
arguments to the function, you can prewarm an entire relation or just 
the blocks you choose; prewarming of blocks from alternate relation 
forks is also supported, for completeness. Hope you like it.
>
>
+1