| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
| Cc: | Steve Crawford <scrawford(at)pinpointresearch(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Excessive growth of pg_attribute and other system tables |
| Date: | 2005-03-21 19:40:30 |
| Message-ID: | 1219.1111434030@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-hackers |
"Matthew T. O'Connor" <matthew(at)zeut(dot)net> writes:
> I believe this discrepancy has to do with the fact that ANALYZE can
> return some very bogus values for reltuples, where as vacuum always
> returns an accurate count. I'm not sure how to best handle this.
I think 8.0's ANALYZE will do a better estimation job ... at least,
Manfred Koizar rewrote the sampling algorithm in hopes of making it
more robust.
However, given that there are 9334 tuples in 82282 pages, I'd say
that autovacuum has already failed Steve rather badly :-(. There
shouldn't be more than a couple hundred pages given that number of
rows. Perhaps the FSM settings are too small?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Browne | 2005-03-21 19:56:30 | Re: Migration from 7.1.3. to 7.4.7. |
| Previous Message | Matthew T. O'Connor | 2005-03-21 19:06:54 | Re: Excessive growth of pg_attribute and other system tables |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Crawford | 2005-03-21 20:35:22 | Re: Excessive growth of pg_attribute and other system tables |
| Previous Message | Tom Lane | 2005-03-21 19:25:47 | Proposal: OUT parameters for plpgsql |