Simon Riggs wrote:
On Wed, 2007-12-12 at 07:36 -0800, Joshua D. Drake wrote:
We can't really expect people to use PITR if they new
it would take hours to recover even on the size of machine I was working on.
That's not true statement in all cases and can often be improved with
some monitoring and tuning. Just get your client to call me :-)
Uhh.. right.
Are you doing replication, or a PITR for another reason?
Warm standby. Normally we pull every 5 minutes which is why we hadn't
noticed this before. However last night we pulled a full sync and
recover and that is when we noticed it.
8 seconds for a single archive recovery is very slow in consideration of
this machine. Even single threaded that seems slow.
Sincerely,
Joshua D. Drake
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/