| 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>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Excessive growth of pg_attribute and other system tables |
| Date: | 2005-03-21 19:06:54 |
| Message-ID: | 423F1B4E.5070507@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:
>
>
>>pg_autovacuum is from 7.4.6 release and is showing periodic vacuums of
>>the problem tables. I thought that bug was in some release prior to
>>7.4.6. Does the bug allow it to show a vacuum taking place but not do
>>it?
>>
>>
>
>I don't recall the details of the changes; you could look at the CVS
>logs to see what got fixed when. But in any case I think we see the
>main problem: max_fsm_pages too small.
>
>
The relevant pg_autovacuum bugs where fixed prior to 7.4.6
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-03-21 19:40:30 | Re: Excessive growth of pg_attribute and other system tables |
| Previous Message | Matthew T. O'Connor | 2005-03-21 18:52:07 | Re: Excessive growth of pg_attribute and other system tables |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2005-03-21 19:23:47 | Re: Very strange query difference between 7.3.6 and 7.4.6 |
| Previous Message | Robert Treat | 2005-03-21 19:05:10 | Re: [HACKERS] what to do with backend flowchart |