On Apr 22, 2008, at 12:04 PM, Vanole, Mike wrote:
It seems that running vacuum still has value in the above approach
because I still see index row versions were removed.
That means either part of the import failed (transaction aborted), or
you're updating or deleting rows between the load an
Hi,
I have an application where I drop, recreate, reload, and recreate
indexes on a 1 million row table each day. I do this to avoid having to
run vacuum on the table in the case where I might use DELETE or UPDATEs
on deltas.
It seems that running vacuum still has value in the above approach
bec
