Re: intel vs amd benchmark for pg server

> The benchmark I am using is the time it takes to vacuum. The
> production server 900MHz celeron takes around 90 seconds. Nightly
> backup dump from the server makes a 3 GB file.

Once other system effects are considered (as noted in earlier responses to your note), may I modestly suggest that OSDB will offer a more interesting benchmark than "the time it takes to vacuum the database?"

(For what you want to do,
1. Download the OSDB and 40MB data tar balls from <http://osdb.sf.net>
2. Execute something like the following...

$ tar zxvf osdb.tgz
$ cd osdb
$ tar zxvf data-40mb.tgz
$ mv data-40mb data
$ ./configure --with-postgresql=/usr/local/pgsql --prefix=./bin
$ bin/osdb-pg-emb --postgresql=no_hash_index
)

/andy

p.s. We're working on a runtime data generator to facilitate testing with much larger datasets, but it's not there yet.

---
Andy Riebs, andy(dot)riebs(at)compaq(dot)com High Performance Technical
(w) 603-884-1521, (fax) 603-884-0630 Computing/Linux Group
<http://cub.sourceforge.net/> Compaq Computer Corporation
(h) ariebs(at)earthlink(dot)net <http://www.compaq.com/linux>
<http://osdb.sourceforge.net/> <http://opensource.compaq.com>