[Bucardo-general] Soemthing weird....

Michelle Sullivan michelle at sorbs.net
Thu Jan 16 16:40:35 UTC 2014


Greg Sabino Mullane wrote:
> On Thu, Jan 16, 2014 at 03:29:49PM +0100, Michelle Sullivan wrote:
>   
>> Yup confirmed... the delete process is being sent to the masters
>> sequentially... this is likely to be a cause of some of the performance
>> issues.  Surely as bucardo holds a connection to each DB independantly
>> it should run the deletes on the same table in parallel to all hosts in
>> the sync and then wait for them all to finish? before completing the
>> transaction - it would probably result in better performance all round..
>>     
>
> The deletes should be happening asynchronously - in other words, 
> all at once. See around line 8520 in git head. For each target, 
> we send a list of rows to be deleted, with pg_async true (hopefully). 
> Once they are all sent off, we wait for them all to finish, then 
> start copying in new rows. If you can confirm that things are not 
> happening asynchronously, it is probably a bug. Lemme commit a 
> quick debug aid to help ... okay, it's in 
> 4c88741a1d579f8c5c8b752eb9eb3a3f698a75d8
>
>   
Not going to be able to install it unfortunately - my production system
is down at the moment (due to this) and it's half way through the
updates...  however if it fails again I will install it.

Michelle

-- 
Michelle Sullivan
http://www.mhix.org/



More information about the Bucardo-general mailing list