Hi Tom,
Thanks for info. I stoped the update and removed the process that's doing
the update and did vacuum analyze. This time the result says
the index row has been removed :
vacuum verbose analyze dsperf_rda_or_key;
INFO: vacuuming "scncraft.dsperf_rda_or_key"
INFO: index "dsperf242_1105" now
Seum-Lim Gan <[EMAIL PROTECTED]> writes:
> vacuum verbose analyze dsperf_rda_or_key;
> INFO: vacuuming "scncraft.dsperf_rda_or_key"
> INFO: index "dsperf242_1105" now contains 30 row versions in 12387 pages
> DETAIL: 3097702 index row versions were removed.
> 0 index pages have been deleted,
Hi Tom,
The key is a range from 1 to 3 and picked randomly.
Oh, so in order to reclaim the disk space, we must run
reindex or vacuum full ?
This will lock out the table and we won't be able to do anything.
Looks like this is a problem. It means we cannot use it for
24x7 operations without hav
Gan,
> Oh, so in order to reclaim the disk space, we must run
> reindex or vacuum full ?
> This will lock out the table and we won't be able to do anything.
> Looks like this is a problem. It means we cannot use it for
> 24x7 operations without having to stop the process and do the vacuum full
> a