| From: | Glen Parker <glenebob(at)nwlink(dot)com> |
|---|---|
| To: | Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Autovacuum Improvements |
| Date: | 2006-12-19 22:11:41 |
| Message-ID: | 4588639D.8040108@nwlink.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Alvaro Herrera wrote:
>>> 4) Expose all information used by autovacuum to form its decisions.
>> You could argue that this is already there, although not easy to get at
>> I suppose. But all table threshold settings are available either in the
>> pg_autovacuum relation or the defaults via GUC variables, that plus a
>> little math will get the information autovacuum uses to form its decisions.
>
> No, we currently don't expose the number of dead tuples which autovacuum
> uses.
I'd prefer to get this working somehow before 8.3. In the mean time, is
this information available at all? I assume a c function could get it,
right? Any easier way?
-Glen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2006-12-19 22:18:25 | Re: Autovacuum Improvements |
| Previous Message | Glen Parker | 2006-12-19 22:09:10 | Re: Autovacuum Improvements |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2006-12-19 22:12:03 | Re: effective_cache_size vs units |
| Previous Message | Peter Eisentraut | 2006-12-19 22:10:22 | Re: effective_cache_size vs units |