-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Tue, 25 Mar 2008 14:16:37 -0400 "Bill Wordsworth" <bill.wordsworth@xxxxxxxxx> wrote: > When traffic goes up, my webserver creates multiple instances of > postgresql.exe. At some basic level, aren't they similar to Oracle's > RAC "clusters", except that they are not aware of each other? Does > this mean that if I were to create copies of postgresql.exe > beforehand and somehow split traffic to them, traffic could be > handled better? Ehh no :). Each of the postgresql.exe is a forked connection to a specific database within PostgreSQL. They may be one database (if you only have one) or many. You could benefit from connection pooling but I have no idea if we have a connection pooler that runs on Windows. > > Also, if I install postgresql on multiple boxes, how can I > load-balance- configure traffic to be split depending on load, at > application or webserver level? That is a *long* conversation. It entirely depends on your business requirements. > > All this for mostly read-only data. > > http://www.postgresql.org/docs/8.3/interactive/high-availability.html That is correct, you can not have multiple write nodes. Sincerely, Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFH6UMGATb/zqfZUUQRAoT0AJ44/gXekfNVfcjl6FhiO03GnqOj9gCgqYRy cmWK72yX/YHFJMqt/6RIZNY= =kM04 -----END PGP SIGNATURE----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general