sCSUVbuMwzZrhQdq4aATH6VII4y4VupI@tg => YSITD: 複雜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}); #5d63e510ef3433d0c93d26a2

sCSUVbuMwzZrhQdq4aATH6VII4y4VupI@tg says to YSITD

複雜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});

at Mon, Aug 26, 2019 9:56 PM