bool / vacuum full bug followup part 2
От | Scott Marlowe |
---|---|
Тема | bool / vacuum full bug followup part 2 |
Дата | |
Msg-id | Pine.LNX.4.33.0205031039280.2391-100000@css120.ihs.com обсуждение исходный текст |
Ответ на | Re: Subject: bool / vacuum full bug followup (Scott Marlowe <scott.marlowe@ihs.com>) |
Ответы |
Re: Subject: bool / vacuum full bug followup part 2
|
Список | pgsql-general |
OK, I remembered what was different. I had an index the first time. So, it was the index I was watchin grow and never shrink. Now this is reproduceable for me. I dropped and recreated my test index drop index test_yn_dx ; create index test_yn_dx on test (yn); vacuum full; [postgres@css120] oid2name -d scott.marlowe All tables from database "scott.marlowe": --------------------------------- 16557 = test 126563 = test_yn_dx cd into the base/oid of my database, then: du -s 16557 126563 11128 16557 1772 126563 update test set yn=true where yn=true; UPDATE 50080 [postgres@css120 16556]$ du -s 16557 126563 16704 16557 2948 126563 vacuum; [postgres@css120 16556]$ du -s 16557 126563 16704 16557 2948 126563 vacuum full; [postgres@css120 16556]$ du -s 16557 126563 11128 16557 4100 126563 I tried: vacuum test_yn_dx; NOTICE: VACUUM: can not process indexes, views or special system tables NOTICE: VACUUM: table not found VACUUM so, then I tried: reindex index test_yn_dx; REINDEX oid2name -d scott.marlowe All tables from database "scott.marlowe": --------------------------------- 16557 = test 126564 = test_yn_dx [postgres@css120 16556]$ du -s 16557 126564 11128 16557 1772 126564 And reclaimed the space. Is that the official way, short of dropping and recreating an index to reclaim its space? Is there a plan to make vacuum reclaim unused space in indexes? Just wondering.
В списке pgsql-general по дате отправления: