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

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

插件 - 中文全文檢索index

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

Recommendations

Last modified: 2019-10-09 02:46:45
Powered by Simple Blog