From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Nigel Metheringham <nigel(dot)metheringham(at)dev(dot)intechnology(dot)co(dot)uk> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Loss of table structure on 7.3.19 |
Date: | 2009-09-17 14:30:36 |
Message-ID: | 10357.1253197836@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Nigel Metheringham <nigel(dot)metheringham(at)dev(dot)intechnology(dot)co(dot)uk> 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
From | Date | Subject | |
---|---|---|---|
Next Message | John P Weatherman | 2009-09-17 14:38:08 | Help with Error |
Previous Message | Nigel Metheringham | 2009-09-17 14:06:36 | Re: Loss of table structure on 7.3.19 |