Re: Hardware suggestions for maximum read performance

Mike,

According to your budget the following or similar might be useful for
you:

HP 365GB Multi Level Cell G2 PCIe ioDrive2 for ProLiant Servers

This PCIe card-based direct-attach solid state storage technology
solutions for application performance enhancement. I believe you can
find cheaper solutions on the market that will provide same performance
characteristics (935,000 write IOPS, up to 892,000 read IOPS, up to 3
GB/s Bandwidth).

Sincerely yours,

Yuri Levinsky, DBA

Celltick Technologies Ltd., 32 Maskit St., Herzliya 46733, Israel

Mobile: +972 54 6107703, Office: +972 9 9710239; Fax: +972 9 9710222

From: pgsql-performance-owner(at)postgresql(dot)org
[mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of Mike McCann
Sent: Friday, May 03, 2013 2:11 AM
To: pgsql-performance(at)postgresql(dot)org
Subject: [PERFORM] Hardware suggestions for maximum read performance

Hello,

We are in the fortunate situation of having more money than time to help
solve our PostgreSQL 9.1 performance problem.

Our server hosts databases that are about 1 GB in size with the largest
tables having order 10 million 20-byte indexed records. The data are
loaded once and then read from a web app and other client programs.
Some of the queries execute ORDER BY on the results. There are typically
less than a dozen read-only concurrent connections to any one database.

SELECTs for data are taking 10s of seconds. We'd like to reduce this to
web app acceptable response times (less than 1 second). If this is
successful then the size of the database will grow by a factor of ten -
we will still want sub-second response times. We are in the process of
going through the excellent suggestions in the "PostgreSQL 9.0 High
Performance" book to identify the bottleneck (we have reasonable
suspicions that we are I/O bound), but would also like to place an order
soon for the dedicated server which will host the production databases.
Here are the specs of a server that we are considering with a budget of
$13k US:

HP ProLiant DL360p Gen 8

Dual Intel Xeon 2.4GHz 4-core E5-2609 CPUs

64GB RAM

2x146GB 15K SAS hard drives

3x200GB SATA SLC SSDs

+ the usual accessories (optical drive, rail kit, dual power
supplies)

Opinions?

Thanks in advance for any suggestions you have.

-Mike

--
Mike McCann
Software Engineer
Monterey Bay Aquarium Research Institute
7700 Sandholdt Road
Moss Landing, CA 95039-9644
Voice: 831.775.1769 Fax: 831.775.1736 http://www.mbari.org

This mail was received via Mail-SeCure System.

=