[Pgcluster-general] async replication

[Kevin Mitchell]

Hi,

First of all, thanks (to Atsushi, and the other contributors) for a
super cool application - Had a look at the  alternatives - PGCluster
beats them hands down!

I got PGCluster (on 8.2.3) working in my environment.
A simple (but very busy - 8000 requests/sec) setup:
	Two Clusters
	One Replicator
	No LB


clust_1 runs the production system, and I need cluster_2 to serve ad-hoc
queries (mainly by application developers for production support).
Problem is: 
When developer queries cluster_2 with an unoptimised query, i.e order by
clause on a field with no index, cluster2 slows down (typically because
of high disk i/o) which causes cluster_1 (which serves the live
customers) to slow-down as well.
If I understand correctly, this is because functions like
PGR_Send_Replicate_Command is synchronous.

My question is this: would it be feasible to add a asynchronous mode to
PGCluster?


Thanks

Kevin

To read FirstRand Bank's Disclaimer for this email click on the following address or copy into your Internet browser: 
https://www.fnb.co.za/disclaimer.html 

If you are unable to access the Disclaimer, send a blank e-mail to
firstrandbankdisclaimer at fnb.co.za and we will send you a copy of the Disclaimer.