Re: [GENERAL] Slow PITR restore

Heikki Linnakangas <heikki@enterprisedb.com> writes:
> Koichi showed me & Simon graphs of DBT-2 runs in their test lab back in 
> May. They had setup two identical systems, one running the benchmark, 
> and another one as a warm stand-by. The stand-by couldn't keep up; it 
> couldn't replay the WAL as quickly as the primary server produced it. 
> IIRC, replaying WAL generated in a 1h benchmark run took 6 hours.

[ shrug... ]  This is not consistent with my experience.  I can't help
suspecting misconfiguration; perhaps shared_buffers much smaller on the
backup, for example.

> One KISS approach would be to just do full page writes more often. It 
> would obviously bloat the WAL, but it would make the replay faster.

... at the cost of making the primary lots slower.
        regards, tom lane