Re: Request for Benchmarks...

Steve Wolfe wrote:
>
>   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.
>
>   However, if anyone is interested, and has any other PG benchmarks on
> them to get some numbers, feel free to let me know.  I'll only have about
> a day to run all of the benchmarks, so they have to be reasonably-sized.
> Once I'm done, I'll make a full report.

All I can say is make sure you are using 7.2 and not an earlier release,
especially for SMP machines, and also look at checkpoint_segments to
prevent checkpointing too often under heavy load.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026