PostgreSQL 非 B-tree 的 index 要定期 reindex 一下


The potential for bloat in non-B-tree indexes has not been well researched. It is a good idea to periodically monitor the index's physical size when using any non-B-tree index type.


如果 index 不是用 B-tree 記得要注意一下這個問題

查 index size 的 SQL 語法在下面

Follow 院長與芊比媽 on Google News