[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