Re: Postgresql Performance on an HP DL385 and - Mailing list pgsql-performance

From Steve Poe
Subject Re: Postgresql Performance on an HP DL385 and
Date
Msg-id 1155010416.17773.1.camel@amd64-gentoo-laptop
Whole thread Raw
In response to Re: Postgresql Performance on an HP DL385 and  ("Luke Lonergan" <llonergan@greenplum.com>)
Responses Re: Postgresql Performance on an HP DL385 and  ("Alex Turner" <armtuk@gmail.com>)
List pgsql-performance
Luke,

Here are the results of two runs of 16GB file tests on XFS.

scsi disc array
xfs ,16G,81024,99,153016,24,73422,10,82092,97,243210,17,1043.1,0,16,3172,7,+++++,+++,2957,9,3197,10,+++++,+++,2484,8
scsi disc array
xfs ,16G,83320,99,155641,25,73662,10,81756,96,243352,18,1029.1,0,16,3119,10,+++++,+++,2789,7,3263,11,+++++,+++,2014,6

Thanks.

Steve



> Can you run bonnie++ version 1.03a on the machine and report the results
> here?
>
> It could be OK if you have the latest Linux driver for cciss, someone has
> reported good results to this list with the latest, bleeding edge version of
> Linux (2.6.17).
>
> - Luke
>


>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match


pgsql-performance by date:

Previous
From: "Steve Poe"
Date:
Subject: Re: Postgresql Performance on an HP DL385 and
Next
From: "Alex Turner"
Date:
Subject: Re: Hardware upgraded but performance still ain't good enough