On Thu, Mar 02, 2006 at 12:30:32PM -0500, Reid Thompson wrote: > Hi all, > I'm querying for feedback/comments. Wondering what the list thinks of > the following. > > Assume this is to provide a production database for a small company or a > department. Production hours 5am-9pm for the most part so night-time > downtime if/when necessary would not be a problem. > > Platform: > SUN ultra 20 or intel/amd based PC > Hard drive1 = OS Solaris 10(+) > Hard drives2 & 3 = ZFS mirrored pool with PostgreSQL intalled > Hard drives4-N = ZFS raided PGDATA > > > Would this be considered viable? > Has anyone implemented anything similar? > Any obvious pitfalls that anyone is aware of? I'd recommend drive 1 & 2 be mirrored witheverything but the table data, which would go on a raid 10 of the rest of the drives via a tablespace. That way you won't lose the box if drive 1 fails. You also probably don't want raid5, if you were thinking about that... -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
