Skip site navigation (1) Skip section navigation (2)

Slow PITR restore

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Slow PITR restore
Date: 2007-12-12 02:18:32
Message-ID: 475F44F8.8050501@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
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

Responses

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2007-12-12 02:39:26
Subject: [hensa22@yahoo.es: Re: [pgsql-es-ayuda] SLL error 100% cpu]
Previous:From: Tom LaneDate: 2007-12-12 00:59:10
Subject: Re: archive_command failures report confusing exit status

pgsql-general by date

Next:From: D. Dante LorensoDate: 2007-12-12 02:23:20
Subject: Function to convert from TEXT to BYTEA?
Previous:From: Matthew DennisDate: 2007-12-12 02:01:09
Subject: Re: Creating Aggregate functions in PLpgSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group