Deploying PostgreSQL on CentOS with SSD and Hardware RAID - Mailing list pgsql-general

From Matt Brock
Subject Deploying PostgreSQL on CentOS with SSD and Hardware RAID
Date
Msg-id B2973756-AA20-4276-ACC3-316E451B849F@mattbrock.co.uk
Whole thread Raw
Responses Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID
List pgsql-general
Hello.

We're intending to deploy PostgreSQL on Linux with SSD drives which would be in a RAID 1 configuration with Hardware
RAID.

My first question is essentially: are there any issues we need to be aware of when running PostgreSQL 9 on CentOS 6 on
aserver with SSD drives in a Hardware RAID 1 configuration? Will there be any compatibility problems (seems unlikely)?
Shouldwe consider alternative configurations as being more effective for getting better use out of the hardware? 

The second question is: are there any SSD-specific issues to be aware of when tuning PostgreSQL to make the best use of
thishardware and software? 

The specific hardware we're planning to use is the HP ProLiant DL360 Gen8 server with P420i RAID controller, and two
MLCSSDs in RAID 1 for the OS, and two SLC SSDs in RAID 1 for the database - but I guess it isn't necessary to have used
thisspecific hardware setup in order to have experience with these general issues. The P420i controller appears to be
compatiblewith recent versions of CentOS, so drivers should not be a concern (hopefully). 

Any insights anyone can offer on these issues would be most welcome.

Regards,

Matt.

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: PG in cash till machines
Next
From: Tom Lane
Date:
Subject: Re: LONG delete with LOTS of FK's