Re: pg_prewarm - Mailing list pgsql-hackers

From Joshua Drake
Subject Re: pg_prewarm
Date
Msg-id 4F59C4CC.2090408@commandprompt.com
Whole thread Raw
In response to pg_prewarm  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
So I wrote a prewarming utility. Patch is attached. You can prewarm either the OS cache or PostgreSQL's cache, and
thereare 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
forksis also supported, for completeness. Hope you like it. <blockquote
cite="mid:CA+TgmobRrRxCO+t6gcQrw_dJw+Uf9ZEdwf9beJnu+RB5TEBjEw@mail.gmail.com"type="cite"><br /><fieldset
class="mimeAttachmentHeader"></fieldset><br/><pre wrap="">
 
</pre></blockquote> +1<br />

pgsql-hackers by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: Measuring relation free space
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: pg_prewarm