Which SCHED_ for DB server

[Roman Neuhauser]

# freebsd at meijome.net / 2005-09-02 10:32:44 +1000:
> Roman Neuhauser wrote:
> ># freebsd at meijome.net / 2005-09-01 18:17:10 +1000:
> >
> >>Holger Kipp wrote:
> >>
> >>>Hello,
> >>>
> >>
> >>>>4 x SATA 150 drives, 90% of it RAID5 with gvinum.
> >>>
> >>>
> >>>I do not know your applications, but if writing to disk is an issue:
> >>>
> >>>- WAL-files should be written to physically separated disks.
> >>
> >>sorry, what do you mean by WAL-files
> >
> > 
> >    Looks like you might greatly benefit from getting acquainted with
> >    PostgreSQL first; you won't be able to tune anything if you don't
> >    know how the software works.
> >
> 
> touche. I've been reading from the documentation from their site and I 
> haven't seen anything on the WAL files...google helped a lot ;)

    http://www.postgresql.org/docs/8.0/static/wal.html

> I think i'll go with 2 separate raid 1 instances given this
> information (and cross the bridge of more storage needed when I get to
> it).

    That sounds reasonable. Good luck with PostgreSQL!

-- 
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.  You don't KNOW.
Cause you weren't THERE.             http://bash.org/?255991