Home > mailing lists

VACCUM FULL ANALYZE PROBLEM - Mailing list pgsql-performance

From	Michael Ryan S. Puncia
Subject	VACCUM FULL ANALYZE PROBLEM
Date	February 15, 2005 04:30:04
Msg-id	200502150126.j1F1QolW028793@mail.census.gov.ph Whole thread Raw
Responses	Re: VACCUM FULL ANALYZE PROBLEM
List	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

From: Kevin Brown
Date: 15 February 2005, 03:11:12
Subject: Re: How to interpret this explain analyse?

From: "Iain"
Date: 15 February 2005, 04:53:52
Subject: Re: VACCUM FULL ANALYZE PROBLEM