Re: [PERFORM] How many Cluster database on a single server

2011-10-20 Thread d.davo...@mastertraining.it
Thanks everybody for the suggestions. Now I have a better idea on which direction proceed. When we will have some results we will post again to share. Thanks again! On 10/19/2011 05:13 PM, Kevin Grittner wrote: "d.davo...@mastertraining.it" wrote: We are thinking to use the Streaming Repli

Re: [PERFORM] How many Cluster database on a single server

2011-10-19 Thread Craig Ringer
On 10/19/2011 05:46 PM, d.davo...@mastertraining.it wrote: My colleagues are asking how many Cluster Databases (initdb) can I create and run on a single server. I mean, supposed my server has the resources, can I create 100 or even 200 Cluster Databases? Yep. It won't be fast, but it'll work.

Re: [PERFORM] How many Cluster database on a single server

2011-10-19 Thread Scott Marlowe
On Wed, Oct 19, 2011 at 9:02 AM, d.davo...@mastertraining.it wrote: > Hi Craig, > thanks for your reply. I think I need to add some details on my question, > like why we would need more than one Cluster Database. We are thinking to > use the Streaming Replica feature to keep in sync a number of li

Re: [PERFORM] How many Cluster database on a single server

2011-10-19 Thread Kevin Grittner
"d.davo...@mastertraining.it" wrote: > We are thinking to use the Streaming Replica feature to keep in > sync a number of little DB servers around the net. The replica > should happen on one or more centralized servers. I didn't tested > the replica personally bus as I can see, it syncs the whol

Re: [PERFORM] How many Cluster database on a single server

2011-10-19 Thread d.davo...@mastertraining.it
Hi Craig, thanks for your reply. I think I need to add some details on my question, like why we would need more than one Cluster Database. We are thinking to use the Streaming Replica feature to keep in sync a number of little DB servers around the net. The replica should happen on one or more

Re: [PERFORM] How many Cluster database on a single server

2011-10-19 Thread Craig James
On 10/19/11 2:46 AM, d.davo...@mastertraining.it wrote: Hi everybody, I googled a bit around and also checked the mailing lists but I still can't make an idea. We plan to use postgres 9 and the Cluster Database Replica. My colleagues are asking how many Cluster Databases (initdb) can I create an

[PERFORM] How many Cluster database on a single server

2011-10-19 Thread d.davo...@mastertraining.it
Hi everybody, I googled a bit around and also checked the mailing lists but I still can't make an idea. We plan to use postgres 9 and the Cluster Database Replica. My colleagues are asking how many Cluster Databases (initdb) can I create and run on a single server. I mean, supposed my server ha