+1
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.
- [HACKERS] pg_prewarm Robert Haas
- Re: [HACKERS] pg_prewarm Jaime Casanova
- Re: [HACKERS] pg_prewarm Joshua Drake
- Re: [HACKERS] pg_prewarm Devrim GÜNDÜZ
- Re: [HACKERS] pg_prewarm Fujii Masao
- Re: [HACKERS] pg_prewarm Robert Haas
- Re: [HACKERS] pg_prewarm Jeff Janes
- Re: [HACKERS] pg_prewarm Robert Haas
- Re: [HACKERS] pg_prewarm Stefan Keller
- Re: [HACKERS] pg_prewarm Robert Haas
- Re: [HACKERS] pg_prewa... Stefan Keller
- Re: [HACKERS] pg_prewarm Robert Haas
- Re: [HACKERS] pg_prewarm Hans-Jürgen Schönig