как это можно мониторить?
Можно. ;) Цитируя src/backend/access/nbtree/README: We consider deleting an entire page from the btree only when it's become completely empty of items. (Merging partly-full pages would allow better space reuse, but it seems impractical to move existing data items left or right to make this happen --- a scan moving in the opposite direction might miss the items if so.) Такие дела. ;(
Обсуждают сегодня