From: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Steve Crawford <scrawford(at)pinpointresearch(dot)com>, 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 21:16:07 |
Message-ID: | 424C6897.1050206@zeut.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-hackers |
Tom Lane wrote:
>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 ???
>
>
Really?!?!?!? Wow, if that is true, that is a big gaping hole in the
autovacuum design. Is that true for all types of system catalog
updates? The reason I ask is that the stats system is reporting at
least some of activity on pg_attribute in this example. So why would it
report some but not all?
Is there any chance fixing the stats system to include system catalog
updates would be simple enough to put into the 8.0.x branch? I don't
know a another way for pg_autovacuum know if it's time for an vacuum.
Hopefully the autovacuum in 8.1 will be a fairly different animal.
From | Date | Subject | |
---|---|---|---|
Next Message | Alexánder Cadavid Giraldo | 2005-03-31 21:28:25 | unsubscribe |
Previous Message | Matthew T. O'Connor | 2005-03-31 21:09:00 | Re: Excessive growth of pg_attribute and other system tables |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2005-03-31 22:13:35 | Re: pg_autovacuum not having enough suction ? |
Previous Message | Matthew T. O'Connor | 2005-03-31 21:09:00 | Re: Excessive growth of pg_attribute and other system tables |