| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Why do we let autovacuum give up? |
| Date: | 2014-01-23 23:12:54 |
| Message-ID: | 52E1A1F6.9090008@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Janes | 2014-01-23 23:13:38 | Re: Why do we let autovacuum give up? |
| Previous Message | Josh Berkus | 2014-01-23 22:55:24 | Re: Why do we let autovacuum give up? |