> Tomas Szepe <[EMAIL PROTECTED]> writes: > >> Are you doing anything that would involve lots of updates in these > >> catalogs --- maybe repeatedly renaming a column, or something like that? > > > Hmm, I typically use a pair of > > "ALTER TABLE table DISABLE TRIGGER USER;"/ > > "ALTER TABLE table ENABLE TRIGGER USER;" > > per almost every relation when loading a dump, other than that there's > > only the initial db creation code (lots of plpgsql triggers and a couple > > immutable functions) and then using temp tables for complicated queries. > > Hm, those ALTERs wouldn't affect pg_attribute. Maybe just using a lot > of temp tables is enough? > > Are you running with autovacuum on, or not?
At the moment autovacuum is off, but it _might_ have been on in the first 40 hours or so... Sorry, I can't say exactly. -- Tomas Szepe <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
