Need help with configuration settings

From: "Barry L(dot) Geipel" <barry(at)GeipelNet(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Need help with configuration settings
Date: 2004-03-22 16:10:22
Message-ID: 02db01c41028$32bcb260$8c83a8c0@future
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I'm currently running the TPC-H benchmark with 25GB of data on a
Linux/PostgreSQL system with the following spec:

2 x Opteron 1.8GHz
16GB RAM
2 x 3ware 8506-8 controllers
12 WD Raptor 74GB drives in two RAID 0 arrays

Can you make any recommendations for system settings?
Should we recompile to change the default page size?
If so, what do you recommend?
Do you have any thoughts on optimum RAID stripe size?

Thanks in advance.

Barry Geipel
barry(at)GeipelNet(dot)com

Browse pgsql-general by date

  From Date Subject
Next Message Randal L. Schwartz 2004-03-22 16:16:17 Re: High Reliability without High Availability?
Previous Message Stephan Szabo 2004-03-22 15:38:08 Re: unsigned types, binary op. and cast pb