| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
| Cc: | Ron <rstpierre(at)syscor(dot)com>, <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: postgresql.conf |
| Date: | 2003-07-30 20:42:24 |
| Message-ID: | 200307301342.24321.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Scott,
> Once someone is getting into the 8 way Itanium II with 32 Gigs of RAM,
> the fact that they are doing something that big means that by looking at
> the default, the workgroup, and the large server configs, they can
> extrapolate and experiment to determine the best settings, and are going
> to need to anyway to get it right.
>
> So, maybe just a note on which parameters to increase if you have more
> RAM/CPU/I/O bandwidth in the big server example?
Also, lets not get away from our goal here, which is NOT to provide
comprehensive documenation (which is available elsewhere) but to give new
DBAs a *sample* config that will perform better than the default.
Plus, I would assume that anybody who spent $50,000 on hardware would be smart
enough to pay a consultant $1000 to tune their database correctly.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-07-30 22:10:24 | Re: Mapping a database completly into Memory |
| Previous Message | scott.marlowe | 2003-07-30 20:09:32 | Re: postgresql.conf |