From: | Richard Neill <rn214(at)cam(dot)ac(dot)uk> |
---|---|
To: | |
Cc: | PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: SSD + RAID |
Date: | 2009-11-20 18:59:57 |
Message-ID: | 4B06E72D.20504@cam.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Axel Rau wrote:
>
> Am 13.11.2009 um 14:57 schrieb Laszlo Nagy:
>
>> I was thinking about ARECA 1320 with 2GB memory + BBU. Unfortunately,
>> I cannot find information about using ARECA cards with SSD drives.
> They told me: currently not supported, but they have positive customer
> reports. No date yet for implementation of the TRIM command in firmware.
> ...
>> My other option is to buy two SLC SSD drives and use RAID1. It would
>> cost about the same, but has less redundancy and less capacity. Which
>> is the faster? 8-10 MLC disks in RAID 6 with a good caching
>> controller, or two SLC disks in RAID1?
Despite my other problems, I've found that the Intel X25-Es work
remarkably well. The key issue for short,fast transactions seems to be
how fast an fdatasync() call can run, forcing the commit to disk, and
allowing the transaction to return to userspace.
With all the caches off, the intel X25-E beat a standard disk by a
factor of about 10.
Attached is a short C program which may be of use.
For what it's worth, we have actually got a pretty decent (and
redundant) setup using a RAIS array of RAID1.
[primary server]
SSD }
} RAID1 -------------------} DRBD --- /var/lib/postgresql
SSD } }
}
}
}
}
[secondary server] }
}
SSD } }
} RAID1 --------gigE--------}
SSD }
The servers connect back-to-back with a dedicated Gigabit ethernet
cable, and DRBD is running in protocol B.
We can pull the power out of 1 server, and be using the next within 30
seconds, and with no dataloss.
Richard
Attachment | Content-Type | Size |
---|---|---|
syncspeed.c | text/x-csrc | 979 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Neill | 2009-11-20 19:00:20 | Re: Postgres query completion status? |
Previous Message | Jonathan Foy | 2009-11-20 18:45:35 | Re: View based upon function won't use index on joins |