Re: [ADMIN] PITR load on servers - increased 20%

2010-03-17 Thread Kevin Grittner
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

[ADMIN] pg_stop_backup()

2010-03-17 Thread Vitaly Burshteyn
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

Re: [ADMIN] pg_stop_backup()

2010-03-17 Thread Bruce Momjian
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