Re: Request for Benchmarks... - Mailing list pgsql-general

From Steve Wolfe
Subject Re: Request for Benchmarks...
Date
Msg-id 00d701c1af65$4fdc9b60$d281f6cc@iboats.com
Whole thread Raw
In response to Request for Benchmarks...  ("Steve Wolfe" <steve@iboats.com>)
List pgsql-general
> >   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



pgsql-general by date:

Previous
From: "Command Prompt, Inc."
Date:
Subject: Re: PgManage (GUI Manager) Update
Next
From: Justin Clift
Date:
Subject: Re: [Fwd: MS SQL compatible functions]