Re: db size and tables size difference - Mailing list pgsql-admin

From Naomi Walker
Subject Re: db size and tables size difference
Date
Msg-id 4AB995D7.3000008@eldocomp.com
Whole thread Raw
In response to Re: db size and tables size difference  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
How would one check for catalog bloat?  And, if bloated, would unloading
and reloading the database
fix it?

Naomi
>
> 3. Bloat in other system catalogs.  5GB of catalog bloat would be
> pretty awful, but maybe that's what it is.
>
> Try that last query without the namespace restrictions.
>
>             regards, tom lane
>
>


--
------------------------------------------------------------------------
Naomi Walker                          Chief Information Officer
Eldorado Computing, Inc               nwalker@eldocomp.com
  ---An EDS Company                   602-604-3100
------------------------------------------------------------------------
Hard things are put in our way, not to stop us, but to call out our
courage and strength. -- Anonymous
------------------------------------------------------------------------


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: db size and tables size difference
Next
From: nalini
Date:
Subject: Re: Recover postgres database