[Bucardo-general] Monitoring Stats / bucardo_rrd

Greg Sabino Mullane greg at endpoint.com
Sat May 18 03:41:09 UTC 2013

> Delete a row (3 nodes), deletes: 3, inserts: 3 (NOT OK?)
> Why is it reporting inserts for a delete action?

That's a good question with a complicated answer. The short version 
is that Bucardo doesn't know how many rows were actually inserted, 
so it defaults to the total possible rows.

What actually happens is a COPY, not an insert. While Postgres does 
report back the number of affected rows (as of 8.3 IIRC), a copy is 
done via $dbh, not a $sth. So, even though DBD::Pg could grab 
the rows via PQcmdTuples, there is no clean place to stick it 
as DBI only defines $sth->rows.

Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130517/94c11ab0/attachment.sig>

More information about the Bucardo-general mailing list