But I need to do full vacuum because I deleted some of the fields that are not use anymore and I also add another fields. Is there
another way to speed up full vacuum?
From: Iain [mailto:iain@mst.co.jp] Sent: Tuesday, February 15, 2005 9:52 AM To: Michael Ryan S. Puncia; pgsql-performance@postgresql.org Subject: Re: [PERFORM] VACCUM FULL ANALYZE PROBLEM
Hi,
just make sure that your freespace map is big enough and then do a vacuum analyse without the full option.
I can imagine that database performance might not be as good as it would be after a vacuum full, though I expect that it wouldn't make much difference.