On Thu, Aug 09, 2007 at 10:22:57AM -0400, Vivek Khera wrote:
>
> On Aug 9, 2007, at 9:38 AM, Brad Nicholson wrote:
>
> >I have the times that it takes to to do a regular
> >vacuum on the clusters, will vacuum full take longer?
>
> almost certainly it will, since it has to move data to compact pa
On Aug 9, 2007, at 9:38 AM, Brad Nicholson wrote:
I have the times that it takes to to do a regular
vacuum on the clusters, will vacuum full take longer?
almost certainly it will, since it has to move data to compact pages
rather than just tagging the rows as reusable.
you can speed thing
I have a couple of database clusters that need a vacuum full, and I
would like to estimate how long it will take, as it will need to be in a
maintenance window. I have the times that it takes to to do a regular
vacuum on the clusters, will vacuum full take longer?
--
Brad Nicholson 416-673-4106
