Re: Bloated pg_shdepend_depender_index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gregory Maxwell" <gmaxwell(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Bloated pg_shdepend_depender_index
Date: 2006-03-24 03:24:12
Message-ID: 21266.1143170652@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Gregory Maxwell" <gmaxwell(at)gmail(dot)com> writes:
> When I vacuum fulled nothing else was connected.. I just restarted PG
> and vacuumed again.. no obvious change of disk size (still.. 6.4
> gigs).. but this changed:

> amarokcollection=# select relname, pg_relation_size(oid) FROM
> pg_class ORDER BY 2 DESC LIMIT 20;
> relname | pg_relation_size
> ---------------------------------+------------------
> pg_attribute_relid_attnam_index | 2881069056
> pg_class_relname_nsp_index | 1185890304

That's in a different database --- evidently, the one where a *whole*
lotta temp tables have been created and dropped. If you haven't been
doing any vacuuming then system catalog bloat is to be expected.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gregory Maxwell 2006-03-24 03:58:11 Re: Bloated pg_shdepend_depender_index
Previous Message Gregory Maxwell 2006-03-24 03:11:40 Re: Bloated pg_shdepend_depender_index