Hi there,
I have to make up a plan for the hardware configuration of a server that
is going to be used only for hosting postgresql. It will be part of a
web application and accessed by several web servers. The server should
therefore be as powerful as possible :-) Unfortunately I could not find
any documentation on the "ideal hardware configuration".
So I am not quite sure about a few things:
- should I go for one or more CPUs? Usually MP CPUs are somewhat
slower than the currently available CPUs for single-cpu-systems.
- I thought about using an external raid subsystem utilizing
raid5 (10x73GB 4MB Cache). Would it be faster to go for several raid10
disk combinations, and moving some data files to these combinations?
- Are there clustering solutions available for postgres? The best
configuration would be somehow extendable if performance increased. But
adding CPUs is not so easy usually. Adding a new server to a cluster
would probably be easier.
- I had a look at several load-balancing and replication apps.
(DBBalancer, PGreplicator, .) Some efforts seem to be discontinued. Did
anyone use some of these systems in a production environment?
Thanks for any help or hints to other documents
Peter Alberer