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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster