| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Glen Parker <glenebob(at)nwlink(dot)com> |
| Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Second attempt, roll your own autovacuum |
| Date: | 2006-12-18 21:52:53 |
| Message-ID: | 20061218215253.GO12526@alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2006-12-18 22:04:20 | Re: feature request for Postgresql Rule system. |
| Previous Message | Richard Broersma Jr | 2006-12-18 21:42:29 | Re: feature request for Postgresql Rule system. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2006-12-18 21:58:53 | Re: pg_restore fails with a custom backup file |
| Previous Message | Andrew Dunstan | 2006-12-18 21:46:28 | Re: pg_restore fails with a custom backup file |