Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group