| From: | Glen Parker <glenebob(at)nwlink(dot)com> |
|---|---|
| To: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Second attempt, roll your own autovacuum |
| Date: | 2006-12-18 22:22:12 |
| Message-ID: | 45871494.1000800@nwlink.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Alvaro Herrera wrote:
> Glen Parker wrote:
>
>> The trouble now is, I don't see how to reset the statistics. My
>> assumption was that vacuum did it, but that appears to be false. How
>> does autovacuum do it? Can I do it with SQL?
>
> Huh, reset what statistics? Autovacuum does not reset anything. What
> statistics are you using? The number of dead tuples _should_ show as
> zero on the stat system after a vacuum, certainly.
pg_stat_user_tables.[n_tup_ins|n_tup_upd|n_tup_del]. Hmm maybe I'm
doing this all wrong then. Is there a way to find the estimated dead
tuples from SQL, the same number autovacuum looks at?
-Glen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lars Heidieker | 2006-12-18 22:38:00 | Re: Stored Procedure and Trigger they puzzle me |
| Previous Message | Jeff Davis | 2006-12-18 22:05:41 | Re: feature request for Postgresql Rule system. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2006-12-18 22:33:23 | Re: [HACKERS] EXPLAIN ANALYZE on 8.2 |
| Previous Message | Magnus Hagander | 2006-12-18 22:01:43 | Re: pg_restore fails with a custom backup file |