title: Configuration Recommendations for a PostgreSQL Installation
body: <p>I have a Windows Server 2003 machine which I will be using as a Postgres database server, the machine is a Dual Core 3.0Ghz Xeon with 4 GB ECC Memory and 4 x 120GB 10K RPM SAS Drives, all stripped.</p>
  
  <p>I have read that the default Postgres install is configured to run nicely on a 486 with 32MB RAM, and I have read several web pages about configuration optimizations - but was hoping for something more concrete from my Stackoverflow peeps.</p>
  
  <p>Generally, its only going to serve 1 database (<strong>potentially</strong> one or two more) but the catch is that the database has 1 table in particular which is massive (hundreds of millions of records with only a few coloumn).  Presently, with the default configuration, <strong>it's not slow</strong>, but I think it could potentially be even faster.</p>
  
  <p>Can people please give me some guidance and recomendations for configuration settings which <em>you</em> would use for a server such as this.  </p>