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

VACCUM FULL ANALYZE PROBLEM

From: "Michael Ryan S(dot) Puncia" <mpuncia(at)census(dot)gov(dot)ph>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: VACCUM FULL ANALYZE PROBLEM
Date: 2005-02-15 01:34:39
Message-ID: 200502150126.j1F1QolW028793@mail.census.gov.ph (view raw or flat)
Thread:
Lists: pgsql-performance
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

can help me solve my problem.

 

Thanks

 

 

Responses

pgsql-performance by date

Next:From: IainDate: 2005-02-15 01:52:01
Subject: Re: VACCUM FULL ANALYZE PROBLEM
Previous:From: Kevin BrownDate: 2005-02-15 00:10:12
Subject: Re: How to interpret this explain analyse?

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