| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | David Mitchell <david(dot)mitchell(at)telogis(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Strange slow database |
| Date: | 2005-11-18 03:28:29 |
| Message-ID: | 1693.1132284509@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
David Mitchell <david(dot)mitchell(at)telogis(dot)com> writes:
> 18/11/2005 03:02:29 INFO: index "pg_attribute_relid_attnam_index" now
> contains 2861 row versions in 11900 pages
> 18/11/2005 03:02:29 DETAIL: 11834 index pages have been deleted, 11834
> are currently reusable.
> 18/11/2005 03:02:30 INFO: index "pg_attribute_relid_attnum_index" now
> contains 2861 row versions in 2942 pages
> 18/11/2005 03:02:30 DETAIL: 2917 index pages have been deleted, 2917
> are currently reusable.
> 18/11/2005 03:02:30 INFO: "pg_attribute": found 0 removable, 2861
> nonremovable row versions in 48 pages
Those indexes are pretty bloated :-( but pg_attribute itself seems to be
nice and tight. I speculate that you did a VACUUM FULL on it recently.
The condition of the indexes suggests strongly that you've not been
vacuuming pg_attribute often enough (and perhaps not any of the other
system catalogs, either?). Heavy use of temp tables will cause
pg_attribute and pg_class to bloat if you don't keep after them.
At the moment, a REINDEX seems to be indicated.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2005-11-18 03:33:42 | Re: Partial foreign keys, check constraints and inheritance |
| Previous Message | Christopher Browne | 2005-11-18 03:09:23 | Re: Rebranding PostgreSQL |