Re: Redundant file server for postgres

What's the expected transaction split (read/write)?

If mostly READs (e.g. SELECTs) then its very, very hard to do better
from a performance perspective than Raid 1 with the transaction log on a
separate array (physically separate spindles)

I run a VERY busy web forum on a Quadcore Intel box with this setup and
it is very fast. Really quite amazing when you get right down to it.

The latest release of the PostgreSQL code markedly improved query
optimization, by the way. The performance improvement when I migrated
over was quite stunning.

Karl Denninger (karl(at)denninger(dot)net)
http://www.denninger.net

Robert Powell wrote:
>
> To whom it may concern,
>
>
>
> I'm looking for a file server that will give me a high level of
> redundancy and high performance for a postgres database. The server
> will be running only postgres as a backend service, connected to a
> front end server with the application on it.
>
> I was thinking along the lines of a RAID 10 setup with a very fast
> processor.
>
>
>
> Any suggestions would be greatly appreciated.
>
>
>
> Bob Powell
>
> The Hotchkiss School
>