Slow PITR restore

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Slow PITR restore
Дата
Msg-id 475F44F8.8050501@commandprompt.com
обсуждение исходный текст
Ответы Re: Slow PITR restore  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Matthew Dennis"
Дата:
Сообщение: Re: Creating Aggregate functions in PLpgSQL
Следующее
От: "D. Dante Lorenso"
Дата:
Сообщение: Function to convert from TEXT to BYTEA?