Slow PITR restore - Mailing list pgsql-general

From Joshua D. Drake
Subject Slow PITR restore
Date
Msg-id 475F44F8.8050501@commandprompt.com
Whole thread Raw
Responses Re: Slow PITR restore
List pgsql-general
Hello,

I have an interesting thing going on here...

2007-12-11 21:10:36 EST     LOG:  restored log file
"00000001000007CC00000012" from archive
2007-12-11 21:10:47 EST     LOG:  restored log file
"00000001000007CC00000013" from archive
2007-12-11 21:11:02 EST     LOG:  restored log file
"00000001000007CC00000014" from archive
2007-12-11 21:11:14 EST     LOG:  restored log file
"00000001000007CC00000015" from archive
2007-12-11 21:11:26 EST     LOG:  restored log file
"00000001000007CC00000016" from archive
2007-12-11 21:11:39 EST     LOG:  restored log file
"00000001000007CC00000017" from archive
2007-12-11 21:11:54 EST     LOG:  restored log file
"00000001000007CC00000018" from archive
2007-12-11 21:12:13 EST     LOG:  restored log file
"00000001000007CC00000019" from archive
2007-12-11 21:12:27 EST     LOG:  restored log file
"00000001000007CC0000001A" from archive
2007-12-11 21:12:42 EST     LOG:  restored log file
"00000001000007CC0000001B" from archive
2007-12-11 21:12:54 EST     LOG:  restored log file
"00000001000007CC0000001C" from archive
2007-12-11 21:13:08 EST     LOG:  restored log file
"00000001000007CC0000001D" from archive
2007-12-11 21:13:21 EST     LOG:  restored log file
"00000001000007CC0000001E" from archive
2007-12-11 21:13:36 EST     LOG:  restored log file
"00000001000007CC0000001F" from archive
2007-12-11 21:13:45 EST     LOG:  restored log file
"00000001000007CC00000020" from archive
2007-12-11 21:13:52 EST     LOG:  restored log file
"00000001000007CC00000021" from archive
2007-12-11 21:14:01 EST     LOG:  restored log file
"00000001000007CC00000022" from archive

Now I understand that restoring log files can be slow but this is a big
machine.

32Gig of Ram
28 Disks (two volumes each raid 10)
Using two different table spaces (over each volume)
8 Opterons.

The machine has a production configuration that can doing several
hundred thousand transactions an hour without so much as having to
stretch first. It seems to me that this machine should be *cranking*
through these transactions. Am I just being my usual uptight, impatient
self?

Sincerely,

Joshua D. Drake

pgsql-general by date:

Previous
From: "Matthew Dennis"
Date:
Subject: Re: Creating Aggregate functions in PLpgSQL
Next
From: "D. Dante Lorenso"
Date:
Subject: Function to convert from TEXT to BYTEA?