Quick Links

Re: loading data, creating indexes, clustering, vacuum...

From:	"Angva" <angvaw(at)gmail(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	Re: loading data, creating indexes, clustering, vacuum...
Date:	2006-12-08 17:33:31
Message-ID:	1165599211.622120.148270@l12g2000cwl.googlegroups.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

> clustering also removes the dead tuples.

I have a followup question. What if the set of dead tuples is too big
and I need to VACUUM FULL, as opposed to VACUUM. (The update size
varies greatly from day to day.) Will the clustering effectively do a
VACUUM FULL, or just a VACUUM?

Thanks again for your help,
Mark

In response to

Re: loading data, creating indexes, clustering, vacuum... at 2006-12-08 14:47:37 from Angva

Responses

Re: loading data, creating indexes, clustering, vacuum... at 2006-12-09 02:48:48 from Bill Moran
Re: loading data, creating indexes, clustering, vacuum... at 2006-12-09 08:25:21 from Shoaib Mir

Browse pgsql-general by date

	From	Date	Subject
Next Message	John Meyer	2006-12-08 17:35:54	Re: Male/female
Previous Message	Madison Kelly	2006-12-08 17:21:47	Re: Male/female