On Mon, Mar 07, 2005 at 08:55:53PM +0100, Marcello Perathoner wrote:
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.
Thanks, and also for the info about squids. I will pitch ibiblio on the idea of a new system - we'll see what the response is. A current top-end quad Xeon system from someplace like asaservers.com is ~$20,000, which is a little steep for PG to pay for. -- Greg
See also:
http://www.ibiblio.org/systems/hardware-details.html
-- Marcello Perathoner webmaster@gutenberg.org
_______________________________________________ gutvol-d mailing list gutvol-d@lists.pglaf.org http://lists.pglaf.org/listinfo.cgi/gutvol-d