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

Re: VACCUM FULL ANALYZE PROBLEM

From: Rod Taylor <pg(at)rbt(dot)ca>
To: "Michael Ryan S(dot) Puncia" <mpuncia(at)census(dot)gov(dot)ph>
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: VACCUM FULL ANALYZE PROBLEM
Date: 2005-02-15 02:21:56
Message-ID: 1108434116.67118.92.camel@home (view raw or flat)
Thread:
Lists: pgsql-performance
On Tue, 2005-02-15 at 09:34 +0800, Michael Ryan S. Puncia wrote:
> Hi,
> 
>  
> 
> I have 3 tables in the database with 80G of data, one of them is
> almost 40G and the remaining 2 tables has 20G each.
> 
> We use this database mainly for query and updating is done only
> quarterly and the database perform well. My problem
> 
> is after updating and then run VACCUM FULL ANALYZE  vacuuming the
> tables takes days to complete. I hope someone

I suspect the VACUUM FULL is the painful part. Try running CLUSTER on
the table or changing a column type (in 8.0) instead.
-- 


In response to

pgsql-performance by date

Next:From: IainDate: 2005-02-15 02:31:14
Subject: Re: VACCUM FULL ANALYZE PROBLEM
Previous:From: Michael Ryan S. PunciaDate: 2005-02-15 02:10:30
Subject: Re: VACCUM FULL ANALYZE PROBLEM

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