Nigel Metheringham <nigel.metheringham@xxxxxxxxxxxxxxxxxxxxxx> writes: > On 17 Sep 2009, at 14:57, Tom Lane wrote: >> The symptoms indicate pretty strongly that you forgot about vacuuming >> the system catalogs. A plain "VACUUM" executed in every database, by >> a superuser, is sufficient for this. Trying to be smart by vacuuming >> only what you think needs vacuumed is not sufficient. > By "in every database" do you mean we need to vacuum the template* > databases too? All the connectable databases, I believe is the rule (although 7.4 was so long it might have done things differently). regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin