On 01/23/2014 02:55 PM, Josh Berkus wrote:
> On 01/23/2014 02:17 PM, Magnus Hagander wrote:
>> FWIW, I have a patch around somewhere that I never cleaned up properly for
>> submissions that simply added a counter to pg_stat_user_tables indicating
>> how many times vacuum had aborted on that specific table. If that's enough
>> info (it was for my case) to cover this case, I can try to dig it out
>> again and clean it up...
>
> It would be 100% more information than we currently have. How much more
> difficult would it be to count completed autovacuums as well? It's
> really the ratio of the two which matters ...
Actually, now that I think about it, the ratio of the two doesn't matter
as much as whether the most recent autovacuum aborted or not.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com