>>> On Wed, Nov 14, 2007 at 3:16 PM, in message
<[EMAIL PROTECTED]>, "Scott Marlowe"
<[EMAIL PROTECTED]> wrote:
> On Nov 14, 2007 2:26 PM, Tena Sakai <[EMAIL PROTECTED]> wrote:
>> INFO: vacuuming "public.allele"
>> INFO: "allele": found 2518282 removable, 1257262 nonremovable row versions
>> in 31511 pages
>> Total free space (including removable row versions) is 161940948 bytes.
> It looks to me like your tables were bloated. After running vacuum
> full your cron should run faster now.
Isn't it usually a good idea to REINDEX after using VACUUM FULL to
recover from this level of bloat?
-Kevin
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
