On 12/6/05, Jan Wieck <[EMAIL PROTECTED]> wrote: > > IMO this is not true. You can get affordable 10GBit network adapters, so > > you can have plenty of bandwith in a db server pool (if they are located in > > the same area). Even 1GBit Ethernet greatly helps here, and would make it > > possible to balance read-intensive (and not write intensive) applications. > > We using linux bonding interface with 2 gbit NICs, and 200 MBytes/sec > > throughput is something you need to have a quite some harddisks to reach > > that. Latency is not bad too. > > It's not so much the bandwidth but more the roundtrips that limit your > maximum transaction throughput. Remember, whatever the priority, you > can't increase the speed of light.
Eh, why would light limited delay be any slower than a disk on FC the same distance away? :) In any case, performance of PG on iscsi is just fine. You can't blame the network... Doing multimaster replication is hard because the locking primitives that are fine on a simple multiprocessor system (with a VERY high bandwidth very low latency interconnect between processors) just don't work across a network, so you're left finding other methods and making them work... But again, multimaster isn't hard because there of some inherently slow property of networks. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
