[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