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

Re: SSD + RAID

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 (view raw or flat)
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: syncspeed.c
Description: text/x-csrc (979 bytes)

In response to

Responses

pgsql-performance by date

Next:From: Richard NeillDate: 2009-11-20 19:00:20
Subject: Re: Postgres query completion status?
Previous:From: Jonathan FoyDate: 2009-11-20 18:45:35
Subject: Re: View based upon function won't use index on joins

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