Re: Hot standby and xlog on a ramdisk

On Thu, Feb 4, 2016 at 3:30 PM, Scott R Mead <scottm(at)openscg(dot)com> wrote:

> > Can a hot standby run correctly with the xlog-files on a ramdisk?
>> >
>>
>> Yes, but, if you lose any, you'll need to rebuild the standby.
>>
>>
> Even if the master and archive contain all the wal files?
>
> If you have the file somewhere, you're okay, whether it's on the master,
> standby or an archive host. If you're using log-shipping, you'll need all
> the WALs.
>

So, just to verify my understanding. Using a ramdisk for pg_xlog on a hot
standby slave should be ok in all cases as long as the archive and master
retains all wal files that are not applied?

I maintain a fairly active database (>100GB of wal files every day) and
putting the wal files on a ramdisk (only for the slaves of course) helped
quite a lot.

--
Eld på åren og sol på eng gjer mannen fegen og fjåg. [Jøtul]
<demo> Tore Halvorsen || +052 0553034554