>> 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?
Hmmm... a full vacuum may help to re-organize the structure of modified tables, but whether this is significant or not is another matter. I don't know enough of the internals to comment on that maybe someone else who knows more can.
The obvious thing is the vacuum memory setting (in postgresql.conf). Presumably, you could set this quite high at least just for the duration of the vacuum anyway.
Would the total time be reduced by dropping the indexes, then vacuuming and rebuilding the indexes? I havn't tried anything like this so I can't say.
You should probably say what version of the db you are using and describe your system a little.
Subject: RE: [PERFORM] VACCUM FULL ANALYZE PROBLEM
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.