On 11/09/2012 05:26 PM, Steve Crawford wrote:
Bloat in pg_attribute would correlate with A) (or any constant
creation/destruction of tables). You can vacuum and/or reindex the
system tables if you are connected as the superuser but you are better
off preventing bloat by appropriate adjustment of your configuration
settings. However note that if you do frequent bulk
creation/destruction of tables you could end up bloating the attribute
table between vacuum runs and may need to periodically manually shrink
it.
Steve,
Our system divides customers into distinct databases, however customers
are often clustered. (Think: different locations of 7/11) and so we have
to aggregate data from different databases. We do this with dblink to
get the data and temp tables to collate it, which appears to be a cause
of the bloat we're seeing.
-Ben
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
