Re: Recovery/Restore and Roll Forward Question.

From: Bruce McAlister <bruce(dot)mcalister(at)blueface(dot)ie>
To: Richard Huxton <dev(at)archonet(dot)com>
Subject: Re: Recovery/Restore and Roll Forward Question.
Date: 2007-06-21 12:03:07
Message-ID: 467A68FB.90004@blueface.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard Huxton wrote:
> Bruce McAlister wrote:
>> Thats exactly what I think. There is something strange going on. At the
>> moment I think it is the disk I am writing the data to that is slow,
>> possibly due to the fact that it is mounted up as "forcedirectio", so as
>> not to interfere with the file system cache which we want to have mainly
>> pg datafiles in, and the RAID controller has this particular logical
>> driver configured as write-through, so there is no buffering in-between.
>> The cpu's and network are not the problem here (2 x Dual Core Opterons
>> and Quad Gigabit Ethernet, total cpu usage is around 10%, NIC's are
>> pushing around 3Mbit/s over each).
>>
>> It's not all that big to be honest, the total database size is around
>> 11GB and I'm currently recking my head to find out how to improve the
>> backup times, and not adversely affect our running instance.
>
> 11GB in 2 hours? Let's see, that's ~1.5MB/sec. Something is horribly
> wrong there - you could do better than that with a USB 1 drive.
>

LOL, now that you put it that way, I'll be sure to put some time in to
get to the bottom of the issue. Jeez, not even USB 2 speeds, maybe i
should hook my thumb drive in the back of the box and send backups there
to prove a point :)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce McAlister 2007-06-21 12:06:41 Re: Recovery/Restore and Roll Forward Question.
Previous Message Gregory Stark 2007-06-21 11:35:06 Re: 8.2.3 PANIC with "corrupted item pointer"