Catalog Bloat

From: Jeff Amiel <jeff(dot)amiel(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Catalog Bloat
Date: 2015-01-30 15:30:31
Message-ID: CAGCx6ndFb8fy=d_+YJqQNGnsqJYfaeL5L-8ShDAW0fVvN4QFwA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Probably temp table related ...but catalog bloat on one of my databases
appears to be pretty bad.

Is the below bloat (table and index) something to worry about?
pg_stat_all_tables show the relations ARE getting successfully vacuumed...

Any suggestions on eliminating? Not sure if tools like pg_reorg are
appropriate (or effective) or even vacuum full (yikes).
I'd prefer not to take a complete outage - but I would if this bloat is
really an issue.

(I know about "reindex system" (duh) - but as that requires me to take an
outage, my question about IF the bloat is a cause for concern still
stands....)

schemaname | tablename | tbloat | wastedbytes | iname
| ibloat | wastedibytes
------------+--------------+--------+-------------+---------------------------------+--------+--------------
pg_catalog | pg_attribute | 9.0 | 27648000 |
pg_attribute_relid_attnam_index | 243.5 | 361627648
pg_catalog | pg_attribute | 9.0 | 27648000 |
pg_attribute_relid_attnum_index | 168.5 | 253894656
pg_catalog | pg_type | 10.8 | 4890624 | pg_type_oid_index
| 135.8 | 28721152
pg_catalog | pg_type | 10.8 | 4890624 | pg_type_typname_nsp_index
| 287.2 | 60956672
pg_catalog | pg_class | 10.3 | 4562944 | pg_class_oid_index
| 94.1 | 26689536
pg_catalog | pg_class | 10.3 | 4562944 | pg_class_relname_nsp_index
| 270.1 | 77144064
pg_catalog | pg_depend | 5.3 | 3948544 |
pg_depend_reference_index | 337.0 | 156901376
pg_catalog | pg_depend | 5.3 | 3948544 | pg_depend_depender_index
| 359.6 | 167436288
pg_catalog | pg_index | 6.1 | 1130496 | pg_index_indexrelid_index
| 72.9 | 7659520
pg_catalog | pg_index | 6.1 | 1130496 | pg_index_indrelid_index
| 72.9 | 7659520
(10 rows)

Thanks in advance

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2015-01-30 15:47:02 Re: pgdump
Previous Message Sterpu Victor 2015-01-30 14:46:50 Re: Subselect with no records results in final empty set