Re: best OS and HW for postgreSQL

On Mon, 2006-09-25 at 10:28, Joshua D. Drake wrote:
> Scott Marlowe wrote:
> > On Sun, 2006-09-24 at 20:18 -0400, Jim Nasby wrote:
> >> On Sep 22, 2006, at 6:12 PM, Raul Retamozo wrote:
> >>> Hi everyone on the list. I want to know what is the reccommended OS
> >>> to work with PostgreSQL , on specific with PostGIS:
> >>> One more question is about what HW (server) offers the best
> >>> performance for a Web Map Server bases on PostGIS and mapserver.
> >> In general, you're probably best off running whatever OS you're most
> >> comfortable with.
> >
> > I'd amend that to say whatever flavor of unix you're most comfortable
> > with.
>
> Well honestly that isn't true either. Linux is faster then Solaris for
> PostgreSQL in a lot of cases. In reality... I would say the best OS for
> PostgreSQL is either Linux or FreeBSD. Win32 is great for a small
> installation or development.
>
> The Solaris argument may change for 8.2, I don't know.

Seems the same thing is true for other databases (the one that cannot be
named comes to mind).

> >
> > Much more important is your disk subsystem. Using an Areca RAID
> > controller with battery backed cache and a half dozen or more hard
> > drives is often the real winner for performance.
>
> Yes, LSI and 3Ware are also good. I am particularly fond of LSI but
> Areca has PCI-Express cards which means you can put them on cheaper
> motherboards :)

I too have a soft spot in my heart for LSI MegaRAID cards. They've
never treated me badly.