{"id":178,"date":"2020-10-01T02:00:27","date_gmt":"2020-09-30T18:00:27","guid":{"rendered":"https:\/\/www.mengqingzhong.com\/?p=178"},"modified":"2021-01-01T19:17:37","modified_gmt":"2021-01-01T11:17:37","slug":"postgresql-index-interface-2","status":"publish","type":"post","link":"https:\/\/www.mengqingzhong.com\/2020\/10\/01\/postgresql-index-interface-2\/","title":{"rendered":"PostgreSQL\u7d22\u5f15(2) \u2013 \u63a5\u53e3"},"content":{"rendered":"

\n\u672c\u6587\u7ffb\u8bd1\u81eaEgor Rogov\u7684\u82f1\u6587\u535a\u5ba2<\/a>\uff0c\u4e14\u5df2\u5f81\u5f97Egor Rogov\u7684\u540c\u610f\u3002\u8bd1\u8005\u505a\u4e86\u5c11\u91cf\u4fee\u6539\u3002\n<\/p>\n

\n\u5ba1\u6821\uff1a\u7eaa\u6600\u7ea2\uff0c\u4e2d\u56fd\u4eba\u6c11\u5927\u5b66\u4fe1\u606f\u5b66\u9662\u5728\u8bfb\u535a\u58eb\u751f\u3002\n<\/p>\n

\u7b2c\u4e00\u7bc7\u6587\u7ae0<\/a>\u4e2d\u63d0\u5230\uff0c\u4e00\u4e2aAM\u5fc5\u987b\u80fd\u591f\u63d0\u4f9b\u5173\u4e8e\u5b83\u81ea\u5df1\u7684\u4fe1\u606f\u3002\u4e0b\u9762\u4ecb\u7ecdAM\u63a5\u53e3\u7684\u7ed3\u6784\u3002<\/p>\n

1. \u5c5e\u6027<\/h1>\n

AM\u7684\u6240\u6709\u5c5e\u6027\u90fd\u5b58\u50a8\u5728pg_am(“am”\u662faccess method\u7684\u7b80\u79f0)\u7cfb\u7edf\u8868\u4e2d\u3002\u6211\u4eec\u53ef\u4ee5\u4ece\u8fd9\u5f20\u7cfb\u7edf\u8868\u4e2d\u67e5\u51fa\u6240\u6709\u53ef\u7528\u7684AM\u5217\u8868\uff1a<\/p>\n

select amname from pg_am;\n<\/code><\/pre>\n
 amname\n--------\n btree\n hash\n gist\n gin\n spgist\n brin\n(6 rows)\n<\/code><\/pre>\n

\u867d\u7136\u987a\u5e8f\u626b\u63cf\u4e5f\u662f\u4e00\u79cdAM\uff0c\u4f46\u7531\u4e8e\u5386\u53f2\u539f\u56e0\uff0c\u5b83\u6ca1\u6709\u88ab\u5217\u5165\u5176\u4e2d\u3002<\/p>\n

\u5728PG 9.5\u53ca\u4e4b\u524d\uff0c\u6bcf\u4e2a\u5c5e\u6027\u7528pg_am\u8868\u4e2d\u7684\u4e00\u4e2a\u5b57\u6bb5\u8868\u793a\u3002\u4ecePG 9.6\u5f00\u59cb\uff0c\u9700\u8981\u4f7f\u7528\u7279\u6b8a\u7684\u51fd\u6570\u67e5\u8be2\u8fd9\u4e9b\u5c5e\u6027\uff0c\u5e76\u4e14\u8fd9\u4e9b\u5c5e\u6027\u88ab\u5206\u4e3a\u4e09\u4e2a\u5c42\u6b21\u3002<\/p>\n