Re: pg_prewarm

Le vendredi 9 mars 2012 16:50:05, Robert Haas a écrit :
> On Fri, Mar 9, 2012 at 10:33 AM, Dimitri Fontaine
>
> <dimitri@2ndquadrant.fr> wrote:
> > So that's complementary with pgfincore, ok.  I still wish we could
> > maintain the RAM content HOT on the standby in the same way we are able
> > to maintain its data set on disk, though.
>
> That's an interesting idea.  It seems tricky, though.

it is the purpose of the latest pgfincore version.
I use a varbit as output of introspection on master, then you are able to
store in a table, stream to slaves, then replay localy.

--
Cédric Villemain +33 (0)6 20 30 22 52
http://2ndQuadrant.fr/
PostgreSQL: Support 24x7 - Développement, Expertise et Formation