Sep 2 – 9, 2007
Victoria, Canada
Europe/Zurich timezone
Please book accomodation as soon as possible.

Evaluating Disk Hardware for Small Deployments of PostgreSQL

Sep 3, 2007, 8:00 AM
10h 10m
Victoria, Canada

Victoria, Canada

Board: 33
poster Software components, tools and databases Poster 1

Speaker

Mr Alexander Withers (Brookhaven National Laboratory)

Description

The PostgreSQL database is a vital component of critical services at the RHIC/USATLAS Computing Facility such as the Quill subsystem of the Condor Project and both PNFS and SRM within dCache. Current deployments are relatively unsophisticated, utilizing default configurations on small-scale commodity hardware. However, a substantial increase in projected growth has exposed deficiencies in this model. Our goal, therefore, is to ensure the scalability and continued availability of our database servers while minimizing costs and administrative overhead. To attain this goal we tested database I/O throughput across a range of inexpensive server and local/external disk configurations in order to determine which was optimal for our environment. This evaluation considered processor type (AMD vs. Intel), disk family (SATA vs. SAS), RAID configuration, and the amount of system memory. Finally, while our evaluation was designed to solve specific problems, we believe that the results of our general tests can be applied to similar deployments of PostgreSQL elsewhere.

Primary author

Mr Alexander Withers (Brookhaven National Laboratory)

Co-authors

Dr Antonio Chan (Brookhaven National Laboratory) Mr Robert Petkus (Brookhaven National Laboratory)

Presentation materials

There are no materials yet.