pgsql is best sql db

複雜index條件

1. CREATE INDEX fact_check_request_hotness ON fact_check_request (((LOG(GREATEST(vote_score, 0) + 1) * 287015) + (created_at / 1000)))

插件 - 位元距離index

2. CREATE INDEX fact_check_request_phash_bktree ON fact_check_request USING spgist (phash bktree_ops)

插件 - 中文全文檢索index

3. CREATE INDEX ${INDEX_NAME} ON ${TABLE_NAME} USING pgroonga (${COLUMN});