pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedanother PITR recovery question
2+ messages / 1 participants
[nested] [flat]
* another PITR recovery question
@ 2009-03-05 21:15 msteben@autorevenue.com
0 siblings, 0 replies; 2+ messages in thread
From: msteben@autorevenue.com @ 2009-03-05 21:15 UTC (permalink / raw)
To: pgsql-admin
I'm running postgres 8.2.5 and I'm running a PITR restore on a
remote machine.
The archived logs are being restored at a rate of about 5 every 3 minutes
I was reading in compressed logs and uncompressing them as they are being
restored. I am now reading in uncompressed logs straight into the restore.
The restore rate only improved slightly - to the rate of 6 every 3 minutes.
Is there something I can do in postgresql.conf or in the shared memory to
get this to move faster? At this rate my recovery will run for days as I'm
copying WAL logs from my production machine.
Thanks
Mark Steben
Autorevenue
Attachments:
untitled-2 (text/html, 4.9K) download
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:Arial;
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Mark Steben
[mailto:msteben@autorevenue.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, March 05, 2009
3:58 PM<br>
<b><span style='font-weight:bold'>To:</span></b> 'pgsql-admin@postgresql.org'<br>
<b><span style='font-weight:bold'>Subject:</span></b> another PITR recovery
question</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I’m running postgres 8.2.5 and I’m running a
PITR restore on a remote machine.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>The archived logs are being restored at a rate of about 5
every 3 minutes<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I was reading in compressed logs and uncompressing them as
they are being restored.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I am now reading in uncompressed logs straight into the
restore.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>The restore rate only improved slightly – to the rate
of 6 every 3 minutes.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Is there something I can do in postgresql.conf or in the
shared memory to<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>get this to move faster? At this rate my recovery will
run for days as I’m copying<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>WAL logs from my production machine. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Thanks<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Mark Steben<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Autorevenue<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
</div>
</body>
</html>
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: another PITR recovery question
@ 2009-03-05 21:46 msteben@autorevenue.com
0 siblings, 0 replies; 2+ messages in thread
From: msteben@autorevenue.com @ 2009-03-05 21:46 UTC (permalink / raw)
To: pgsql-admin
May be helpful to add on some memory information to my question:
shared_buffers - 250MB
work_mem - 75 MB
maintenance_work_mem - 100MB
max_fsm_pages - 1500000
wal_buffers - 96
checkpoint_segments - 32
And some information on the machine (VMWARE)
ipcs -l
------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 4194303
max total shared memory (kbytes) = 1073741824
min seg size (bytes) = 1
This is the only process running on this virtual machine.
Thanks,
Mark
>
> I'm running postgres 8.2.5 and I'm running a PITR restore on a
> remote machine.
> The archived logs are being restored at a rate of about 5 every 3 minutes
> I was reading in compressed logs and uncompressing them as they are being
> restored. I am now reading in uncompressed logs straight into the restore.
>
> The restore rate only improved slightly - to the rate of 6 every 3
> minutes.
>
> Is there something I can do in postgresql.conf or in the shared memory to
> get this to move faster? At this rate my recovery will run for days as
> I'm
> copying WAL logs from my production machine.
>
>
> Thanks
>
>
>
> Mark Steben
>
> Autorevenue
>
>
>
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2009-03-05 21:46 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-03-05 21:15 another PITR recovery question msteben@autorevenue.com
2009-03-05 21:46 Re: another PITR recovery question msteben@autorevenue.com
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox