Is this correct?
vacuum by itself just cleans out the old extraneous tuples so that they
aren't in the way anymore
vacuum analyze rebuilds indexes. If you add an index to a table it won't be
used until you vacuum analyze it
vacuum full actually compresses the table on disk by reclaiming the space
from the old tuples after they have been removed.
----- Original Message -----
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Paulo Jan" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, November 12, 2003 8:38 AM
Subject: Re: [GENERAL] Perfomance difference between 7.2 and 7.3
> Paulo Jan <[EMAIL PROTECTED]> writes:
> > -> Seq Scan on todocinetv (cost=0.00..37768.90 rows=28792
> > width=8)
>
> The estimated cost seems to be more than one disk page read per row
> returned. This suggests to me that you have a huge amount of dead space
> in that table --- try a VACUUM FULL on it. If that fixes the problem,
> then you need to improve your housekeeping procedures on the 7.2
> installation: run vacuums more often and ensure that your FSM settings
> are large enough.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to [EMAIL PROTECTED] so that your
> message can get through to the mailing list cleanly
>
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
