After a long battle with technology, reid.thompson@xxxxxxxx (Reid Thompson), an earthling, 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? This is, in principle, a pretty generic sort of configuration that ought to be fine for a not-overly-heavily loaded departmental sort of application. We have much smaller systems than that in production for applications that don't take much load. There are also much bigger systems to cope with cases that are definitely bigger than what you describe. You haven't described the nature of your application, so there is no particular reason to believe this hardware to either be adequate or inadequate... Something worth considering is that if you use replication (e.g. - something like Slony-I), you could quite likely live with having several cheaper boxes. Individually, they may not be as reliable as the pricier one, but in aggregate, you should, via techniques like "moving master," keep higher uptimes than a single cheap box could support. -- "cbbrowne","@","gmail.com" http://cbbrowne.com/info/slony.html "There is no psychiatrist in the world like a puppy licking your face." -- Ben Williams
