Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group