> > I mentioned this in another message, but I'll reiterate it for
> > everyone's sake. In a day or two, I'll have the chance to pit two
> > machines against each other to test their capacity at serving out
queries
> > with Postgres - a dual Athlon MP 1800+ and a quad 700 MHz Xeon, both
> > running Linux. The benchmark I'm planning on running involves a
sample of
> > queries taken from our day-to-day production, so that would most
likely
> > reflect what *I* can expect out of the machine.
>
> You'll want to make sure both machines have comparable disk
> subsystems; otherwise you won't be comparing what you think you're
> comparing...
I plan on making sure that the database is entirely in disk cache, so
that the disk subsystem drops out of the picture.
steve