On Sun, 2007-01-21 at 06:55 -0800, brian stone wrote: > Are there any built in tools or 3rd party tools for distributing a > postgresql database? I need an active active configuration; master- > master with fail over. The project I am working needs to support a > very large number of transactions a second. It will eventually require > a main frame, or some absurd hardware. It makes much more sense to > consider a clustered configuration. DB requests come in from a row of > application servers. It would be nice if these requests could be > distributed. > Consider pgpool, and look at the partitioning feature (which uses different machines for different records, allowing writes to happen very quickly). Also, depending on what your needs are, a relational database might not be right for you. You say you need transactions, but if you're comparing to MySQL's master-master, I don't think that even supports ACID transactions. Do you actually need transactions, or just many writes per second (perhaps to memory rather than disk)? Regards, Jeff Davis
