官术网_书友最值得收藏!

Testing custom operator classes

In our example, the test data consists of just two rows. Therefore, PostgreSQL will never use an index because the table is just too small to justify the overhead of even opening the index. To be able to still test without having to load too much data, you can advise the optimizer to make sequential scans more expensive. Making operations more expensive can be done inside your session using the following instruction:

SET enable_seqscan TO off;

The index works as expected:

test=# explain SELECT * FROM t_sva WHERE sva = '0000112273'; 
QUERY PLAN
------------------------------------------------------------------
Index Only Scan using idx_special on t_sva (cost=0.13..8.14 rows=1 width=32)
Index Cond: (sva = '0000112273'::text)
(2 rows)

test=# SELECT * FROM t_sva;

sva
------------
2345010477
1118090878
(2 rows)
主站蜘蛛池模板: 瓦房店市| 荔浦县| 白河县| 四子王旗| 新沂市| 大英县| 香港 | 拜泉县| 霍邱县| 贵定县| 贵德县| 黄浦区| 乌恰县| 平南县| 沙河市| 辽中县| 轮台县| 观塘区| 睢宁县| 汤原县| 清原| 沈阳市| 贵德县| 象州县| 仁怀市| 庄河市| 宁津县| 琼结县| 香格里拉县| 龙泉市| 华蓥市| 南陵县| 罗平县| 高淳县| 如东县| 乌拉特后旗| 惠州市| 鲁甸县| 波密县| 常宁市| 潍坊市|