Re: [PERFORM] Performance of archive logging in a PITR restore

2009-03-18 Thread Heikki Linnakangas
Joshua D. Drake wrote: On Mon, 2009-03-16 at 12:11 -0400, Mark Steben wrote: The issue is that during a restore on a remote site, (Postgres 8.2.5) 8.2.5 is quite old. You should upgrade to the latest 8.2.X release. archived logs are taking an average of 35 – 40 seconds apiece to restore.

[PERFORM] Performance of archive logging in a PITR restore

2009-03-16 Thread Mark Steben
First of all, I did pose this question first on the pgsql - admin mailing list. And I know it is not appreciated to post across multiple mailing lists so I Apologize in advance. I do not make it a practice to do so but, this being A performance issue I think I should have inquired on this list

Re: [PERFORM] Performance of archive logging in a PITR restore

2009-03-16 Thread Joshua D. Drake
On Mon, 2009-03-16 at 12:11 -0400, Mark Steben wrote: First of all, I did pose this question first on the pgsql – admin mailing list. The issue is that during a restore on a remote site, (Postgres 8.2.5) archived logs are taking an average of 35 – 40 seconds apiece to restore. Archive