Re: [HACKERS] pg_dump's aborted transactions

2015-02-04 Thread Stephen Frost
* Robert Haas (robertmh...@gmail.com) wrote: > On Wed, Feb 4, 2015 at 8:08 AM, Stephen Frost wrote: > > Apologies for the confusion- the client isn't using it to determine if > > there's activity. They're using it exactly as it's intended, as I > > understand it- to check and see if the number of

Re: [HACKERS] pg_dump's aborted transactions

2015-02-04 Thread Robert Haas
On Wed, Feb 4, 2015 at 8:08 AM, Stephen Frost wrote: > Apologies for the confusion- the client isn't using it to determine if > there's activity. They're using it exactly as it's intended, as I > understand it- to check and see if the number of rollbacks is > signifigant compared to the number of

Re: [HACKERS] pg_dump's aborted transactions

2015-02-04 Thread Stephen Frost
* Guillaume Lelarge (guilla...@lelarge.info) wrote: > 2015-02-04 6:37 GMT+01:00 Tom Lane : > > Stephen Frost writes: > > No, somebody should fix check_postgres to count rollbacks as well as > > commits as activity (as they obviously are). > > > Well, actually, no. This is a commit ratio, not an ac

Re: [HACKERS] pg_dump's aborted transactions

2015-02-04 Thread Guillaume Lelarge
2015-02-04 6:37 GMT+01:00 Tom Lane : > Stephen Frost writes: > > All, > > We recently had a client complain that check_postgres' commitratio > > check would alert about relatively unused databases. As it turns > > out, the reason for this is because they automate running pg_dump > > agai

Re: [HACKERS] pg_dump's aborted transactions

2015-02-03 Thread Tom Lane
Stephen Frost writes: > All, > We recently had a client complain that check_postgres' commitratio > check would alert about relatively unused databases. As it turns > out, the reason for this is because they automate running pg_dump > against their databases (surely a good thing..), but p

[HACKERS] pg_dump's aborted transactions

2015-02-03 Thread Stephen Frost
All, We recently had a client complain that check_postgres' commitratio check would alert about relatively unused databases. As it turns out, the reason for this is because they automate running pg_dump against their databases (surely a good thing..), but pg_dump doesn't close out its t