Обсуждение: Postgresql Performance via the LSI MegaRAID 2x Card

Past recommendations for a good RAID card (for SCSI) have been the LSI
MegaRAID 2x. This unit comes with 128MB of RAM on-board. Has anyone
found by increasing the on-board RAM, did Postgresql performed better?

Thanks.

Steve Poe

Steve,

> Past recommendations for a good RAID card (for SCSI) have been the LSI
> MegaRAID 2x. This unit comes with 128MB of RAM on-board. Has anyone
> found by increasing the on-board RAM, did Postgresql performed better?

My informal tests showed no difference between 64MB and 256MB.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

I'm sure there's some corner case where more memory helps. If you
consider that 1GB of RAM is about $100, I'd max out memory on the
controller just for the hell of it.


Josh Berkus wrote:

> Steve,
>
>
>>Past recommendations for a good RAID card (for SCSI) have been the LSI
>>MegaRAID 2x. This unit comes with 128MB of RAM on-board. Has anyone
>>found by increasing the on-board RAM, did Postgresql performed better?
>
>
> My informal tests showed no difference between 64MB and 256MB.
>

William,

> I'm sure there's some corner case where more memory helps.

QUite possibly.   These were not scientific tests.

--
Josh Berkus
Aglio Database Solutions
San Francisco