Re: "Vacuum Full Analyze" taking so long

From: Michael Stone <mstone+postgres(at)mathom(dot)us>
To: "Tomeh, Husam" <htomeh(at)firstam(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: "Vacuum Full Analyze" taking so long
Date: 2005-07-25 21:30:58
Message-ID: 20050725213058.GQ19080@mathom.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I'd say, "don't do that". Unless you've deleted a lot of stuff and are
expecting the DB to shrink, a full vacuum shouldn't really be needed. On
a DB that big a full vacuum is just going to take a long time. If you
really are shrinking, consider structuring things so you can just drop a
table instead of vacuuming it (the drop is fairly instantaneous). If you
can't do that, consider dropping the indices, vacuuming, and recreating
the indices.

Mike Stone

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Chris Isaacson 2005-07-25 22:32:50 COPY insert performance
Previous Message Tomeh, Husam 2005-07-25 21:30:24 "Vacuum Full Analyze" taking so long