Seum-Lim Gan <[EMAIL PROTECTED]> writes:
> INFO: vacuuming "craft.dsperf_rda_or_key"
> INFO: index "hello242_1105" now contains 1792276 row versions in 6237 pages
> DETAIL: 0 index pages have been deleted, 0 are currently reusable.
> CPU 0.61s/0.36u sec elapsed 17.92 sec.
> INFO: "hello_rda_or_
Hi Tom,
I did that when I have stopped my updates.
Now, I am doing updates below is the output of vacuum.
After doing the vacuum verbose analyze, it reported the following :
INFO: vacuuming "craft.dsperf_rda_or_key"
INFO: index "hello242_1105" now contains 1792276 row versions in 6237 pages
DET
Seum-Lim Gan <[EMAIL PROTECTED]> writes:
> Sample verbose analyze:
> VACUUM VERBOSE ANALYZE hello_rda_or_key;
> INFO: vacuuming "craft.hello_rda_or_key"
> INFO: index "hello242_1105" now contains 740813 row versions in 2477 pages
So what's the problem? That doesn't seem like a particularly blo
Hi Josh,
Sample verbose analyze:
VACUUM VERBOSE ANALYZE hello_rda_or_key;
INFO: vacuuming "craft.hello_rda_or_key"
INFO: index "hello242_1105" now contains 740813 row versions in 2477 pages
DETAIL: 0 index pages have been deleted, 0 are currently reusable.
CPU 0.42s/0.13u sec elapsed 4.76 sec.
Gan,
> Is the index bloating issue still not resolved in 7.4beta4 ?
No, it should be. Please post your max_fsm_pages setting, and the output of a
sample VACUUM VERBOSE ANALYZE. You probably don't have your FSM set right.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
--
Hi,
I downloaded PostgreSQL 7.4beta4 and tried it out.
It turns out that the index file is still bloating even
after running vacuum or vacuum analyze on the table.
Still, only reindex will claim the space back.
Is the index bloating issue still not resolved in 7.4beta4 ?
Thanks.
Gan
--
+---
