| From: | "Marinos J(dot) Yannikos" <mjy(at)geizhals(dot)at> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to make a REALLY FAST db server? |
| Date: | 2001-09-23 22:17:23 |
| Message-ID: | 3BAE5F73.3080205@geizhals.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Marshall Spight wrote:
> Do you have some data to back this up? I'd be interested in any
> published reports, benchmarks, or even the experience you mention,
> if you took measurements.
Someone could volunteer to collect pgbench results for various
configurations. I'd be very interested, since we're about to
purchase a new RAID system and considering the 3ware Escalade
series vs. several SCSI controllers...
Collected data should include:
- OS/Version
- File system
- CPUs & RAM (including type of RAM, i.e. PC133, DDR, Rambus...)
- Controller & RAID configuration
- PostgreSQL version & configuration (e.g. "-F -B512 -o '-S 65536'")
Useful parameters for pgbench would probably be:
pgbench -c1 -t 1000
pgbench -c4 -t 1000
pgbench -c10 -t 1000
Comments? Volunteers?
-mjy
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lee Harr | 2001-09-23 22:23:05 | Re: My brain hurts - update field based on value of another table's field |
| Previous Message | Chris | 2001-09-23 21:59:51 | Re: creating "user" table |