Renato Oliveira wrote:
> I have been testing PITR and I have noticed a 20% increase on the
> load of the Disk subsystem.
>
> Is that a normal thing to expect?
It depends on your workload and archive script, but that doesn't
seem too shocking.
For one thing, turning on archiving causes more
Out of curiosity, any idea why every time I run select pg_stop_backup(); it
goes into an infinite loop? While the first part of this select
pg_start_backup(‘label’) works without any issues??
Vitaly Burshteyn
Senior Network Engineer
Broadway.com, Theatre Direct International
729 7th
Vitaly Burshteyn wrote:
> Out of curiosity, any idea why every time I run select
> pg_stop_backup(); it goes into an infinite loop? While the
> first part of this select pg_start_backup(?label?) works without
> any issues??
pg_start_backup() is waiting for the archives to be stored. I would
lo