| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
| Cc: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, Jan Wieck <JanWieck(at)Yahoo(dot)com>, pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Re: [ADMIN] Excessive growth of pg_attribute and other system tables |
| Date: | 2005-03-31 19:04:08 |
| Message-ID: | 7739.1112295848@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-hackers |
Steve Crawford <scrawford(at)pinpointresearch(dot)com> writes:
> On Monday 21 March 2005 11:40 am, Tom Lane wrote:
>> 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?
> Results time. FSM settings were too small but the real problem seems
> to be that pg_autovacuum isn't getting the job done.
The light just went on ... system catalog updates don't generate
statistics reports. Hence, autovacuum doesn't know any work is needed.
Should we fix that, or change autovacuum to special-case the system
catalogs somehow, or ???
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-03-31 20:06:13 | Re: [ADMIN] Excessive growth of pg_attribute and other system tables |
| Previous Message | Joel Fradkin | 2005-03-31 19:00:03 | Re: connectivity to database been an issue for me. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2005-03-31 19:06:38 | Re: [COMMITTERS] pgsql: Translation updates |
| Previous Message | Alvaro Herrera | 2005-03-31 18:45:15 | Re: [COMMITTERS] pgsql: Translation updates |