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

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)
主站蜘蛛池模板: 宁国市| 枞阳县| 鹤庆县| 金坛市| 交城县| 六枝特区| 丰原市| 类乌齐县| 柞水县| 深圳市| 平原县| 自治县| 湛江市| 盐边县| 敦煌市| 镇赉县| 合肥市| 宾阳县| 南漳县| 乌鲁木齐市| 通州市| 龙里县| 汉寿县| 桃园县| 郁南县| 车致| 东安县| 彰化县| 莆田市| 冀州市| 屯昌县| 喀喇| 闵行区| 平果县| 高要市| 西乌珠穆沁旗| 张家港市| 板桥市| 北票市| 沁阳市| 渭源县|