Brandon Galbraith wrote:
Maybe it's time to talk about doing a master/slave replication configuration of postgres to handle the database load. If you want, contact me off list and I'd be willing to help any way I can.
First ibiblio will have to host another database server and dedicate that server to PG. A dedicated database server would probably solve our problem. But we'll have to talk the ibiblio people into doing that for us. It means money, more maintenance hassles and maybe problems from other sites hosted at ibiblio, who want a faster server too. OTOH a dedicated squid for PG would help too and be much cheaper. Replication to an external server will not help much, as the latency will be too big. Our current database server is: IBM Netfinity 6000R Quad Xeon PIII 700 MHz 4.5 GB RAM 108 GB storage iblinux But this one is shared with other sites hosted at ibiblio. See also: http://www.ibiblio.org/systems/hardware-details.html -- Marcello Perathoner webmaster@gutenberg.org