Re: [PERFORM] Postgresql Performance via the LSI MegaRAID 2x Card

2005-05-15 Thread Josh Berkus 
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

Re: [PERFORM] Postgresql Performance via the LSI MegaRAID 2x Card

2005-05-15 Thread William Yu 
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.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
  http://www.postgresql.org/docs/faq

Re: [PERFORM] Postgresql Performance via the LSI MegaRAID 2x Card

2005-05-13 Thread Josh Berkus 
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

[PERFORM] Postgresql Performance via the LSI MegaRAID 2x Card

2005-05-13 Thread Steve Poe 
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