Re: RAID 1 - drive failed - very slow queries even after drive replaced

From: tv(at)fuzzy(dot)cz
To: "Merrick" <merrick(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: RAID 1 - drive failed - very slow queries even after drive replaced
Date: 2011-03-23 09:25:01
Message-ID: 78c68456526930bd70d2c8a63c873fa6.squirrel@sq.gransy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Hi,
>
> I am looking for some advice on where to troubleshoot after 1 drive in
> a RAID 1 failed.
>
> Thank you.
>
> I am running v 7.41, I am currently importing the data to another
> physical server running 8.4 and will test with that once I can. In the
> meantime here is relevant info:
>
> Backups used to take 25 minutes, and now take 110 minutes, before
> replacing the drive it became clear the backup was not going to finish
> since in 120 minutes it had only finished 200mb of 2.8gb.

What kind of RAID is this? I know it's RAID1, but is it built using linux
sw raid (md), or is it some other solution (like a hw card)? Can you post
some diagnostics info like

mdadm --detail /dev/md1

or something like that? I guess this would be reflected in the iostat
output (at least for the 'md') but I'm not sure. Maybe there's something
still in progress (sync of the new drive?).

Tomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message tv 2011-03-23 09:32:11 Re: Utilities for managing streaming replication servers?
Previous Message John R Pierce 2011-03-23 09:18:22 Re: Utilities for managing streaming replication servers?