>>> On Wed, Nov 14, 2007 at 3:16 PM, in message
<dcc563d10711141316u53338170l5d31d7723c8dc30b@xxxxxxxxxxxxxx>, "Scott Marlowe"
<scott.marlowe@xxxxxxxxx> wrote:
> On Nov 14, 2007 2:26 PM, Tena Sakai <tsakai@xxxxxxxxxxxxxx> 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
