{"id":510,"date":"2026-05-17T07:04:11","date_gmt":"2026-05-16T23:04:11","guid":{"rendered":"https:\/\/junai.ai\/blog\/pg-indexes-16\/"},"modified":"2026-05-17T07:04:11","modified_gmt":"2026-05-16T23:04:11","slug":"pg-indexes-16","status":"publish","type":"post","link":"https:\/\/junai.ai\/blog\/pg-indexes-16\/","title":{"rendered":"\uc778\ub371\uc2a4 \u2014 B-Tree\u00b7GIN\u00b7BRIN (\uc911\uae09 16\ud3b8)"},"content":{"rendered":"\n<!-- WordPress REST API \ubc1c\ud589\uc6a9 HTML (\uc790\ub3d9 \uc0dd\uc131) -->\n<!-- WP-FEATURED-MEDIA-ID: 302 -->\n<div style=\"max-width:800px;margin:0 auto;\">\n<style>\n:root{--color-primary:#336791;--color-accent:#60a5fa;--color-bg:#fafafa;--color-bg-card:#ffffff;--color-text:#1e293b;--color-text-muted:#64748b;--hero-start:#0f172a;--hero-end:#336791;--font-body:-apple-system,BlinkMacSystemFont,'Apple SD Gothic Neo','Noto Sans KR',sans-serif;--size-body:17px;--line-height:1.75;}\n*{box-sizing:border-box;}\n.container{max-width:760px;margin:0 auto;padding:0 22px 80px;}\n.hero{background:linear-gradient(135deg,var(--hero-start) 0%,var(--hero-end) 100%);color:#fff;padding:72px 22px 56px;text-align:center;}\n.hero .badge{display:inline-block;background:rgba(96,165,250,0.18);color:var(--color-accent);padding:6px 14px;border-radius:999px;font-size:13px;font-weight:600;letter-spacing:0.5px;margin-bottom:18px;}\n.hero h1{margin:0 0 18px;font-size:36px;line-height:1.3;letter-spacing:-0.3px;}\n.hero p.sub{margin:0 auto;max-width:580px;font-size:17px;color:#bfdbfe;}\n.hero img{width:100%;max-width:720px;height:auto;margin:36px auto 0;display:block;border-radius:10px;box-shadow:0 8px 32px rgba(0,0,0,0.3);}\n.meta{display:flex;gap:14px;justify-content:center;margin-top:20px;font-size:13px;color:#93c5fd;flex-wrap:wrap;}\n.meta span::before{content:\"\u00b7\";margin-right:14px;color:#1e3a8a;}\n.meta span:first-child::before{content:\"\";margin:0;}\narticle{background:var(--color-bg-card);margin-top:-36px;padding:44px 28px;border-radius:14px;box-shadow:0 2px 18px rgba(0,0,0,0.06);}\narticle p{margin:0 0 18px;}\nh2{font-size:28px;line-height:1.35;letter-spacing:-0.3px;margin:48px 0 18px;padding-bottom:10px;border-bottom:2px solid var(--color-primary);}\nh2:first-of-type{margin-top:8px;}\nh3{font-size:21px;line-height:1.4;margin:30px 0 12px;color:var(--color-primary);}\ncode{background:#f1f5f9;color:#0f172a;padding:2px 6px;border-radius:4px;font-family:'SFMono-Regular',Menlo,Consolas,monospace;font-size:0.92em;}\npre{background:#0f172a;color:#e2e8f0;padding:18px 20px;border-radius:10px;overflow-x:auto;font-size:14.5px;line-height:1.65;margin:18px 0;}\npre code{background:transparent;color:inherit;padding:0;}\nul,ol{margin:0 0 18px;padding-left:24px;}\nli{margin-bottom:8px;}\nstrong{color:#0f172a;}\n.databox{background:#eff6ff;border-left:4px solid var(--color-primary);padding:18px 20px;border-radius:6px;margin:22px 0;}\n.databox p{margin:0 0 8px;}\n.databox p:last-child{margin:0;}\n.databox strong{color:var(--color-primary);}\n.warnbox{background:linear-gradient(135deg,#fef3c7 0%,#fde68a 100%);border-left:4px solid #d97706;padding:18px 20px;border-radius:6px;margin:22px 0;}\n.warnbox strong{color:#92400e;}\n.tablewrap{overflow-x:auto;-webkit-overflow-scrolling:touch;margin:22px 0;}\ntable{width:100%;border-collapse:collapse;font-size:15px;background:var(--color-bg-card);}\nth,td{padding:11px 12px;text-align:left;border-bottom:1px solid #e2e8f0;vertical-align:top;}\nth{background:#f1f5f9;font-weight:700;color:#0f172a;}\ntd:first-child,th:first-child{font-weight:700;}\n.cta{background:linear-gradient(135deg,#336791 0%,#60a5fa 100%);color:#fff;padding:30px 24px;border-radius:12px;margin-top:44px;text-align:center;}\n.cta h3{color:#fff;margin:0 0 10px;}\n.cta p{margin:0;color:#dbeafe;}\n.series-nav{background:#eff6ff;padding:18px 22px;border-radius:10px;margin-top:24px;font-size:14.5px;color:var(--color-text-muted);}\n.series-nav strong{color:var(--color-primary);}\n@media (max-width:480px){.hero{padding:52px 18px 44px;}.hero h1{font-size:26px;}.hero p.sub{font-size:15px;}article{padding:28px 18px;border-radius:10px;}h2{font-size:22px;}h3{font-size:18px;}body{font-size:16px;}pre{font-size:13px;padding:14px 16px;}}\n@media (max-width:560px){.tablewrap table,.tablewrap thead,.tablewrap tbody,.tablewrap tr,.tablewrap th,.tablewrap td{display:block;width:auto;}.tablewrap thead{display:none;}.tablewrap tr{margin:0 0 14px;border:1px solid #e2e8f0;border-radius:10px;overflow:hidden;}.tablewrap td{border:none;border-bottom:1px solid #f1f5f9;padding:9px 14px;}.tablewrap td:first-child{background:#eff6ff;font-weight:800;font-size:15.5px;}.tablewrap td:last-child{border-bottom:none;}.tablewrap td[data-label]::before{content:attr(data-label) \" \u2014 \";font-weight:700;color:var(--color-primary);}}\n<\/style>\n<header class=\"hero\">\n  <span class=\"badge\">PostgreSQL \uad50\uc7ac \u00b7 16\ud3b8 \/ 24\ud3b8<\/span>\n  <h1>\uc778\ub371\uc2a4 \u2014 B-Tree\u00b7GIN\u00b7BRIN<\/h1>\n  <p class=\"sub\">\uc778\ub371\uc2a4 \uc885\ub958 5\uac00\uc9c0\uc640 multi-column\u00b7partial\u00b7covering \uc804\ub7b5.<\/p>\n  <div class=\"meta\"><span>\uc911\uae09<\/span><span>\uc77d\ub294 \uc2dc\uac04 8\ubd84<\/span><span>2026-05-17<\/span><\/div>\n  <img decoding=\"async\" src=\"https:\/\/junai.ai\/blog\/wp-content\/uploads\/2026\/05\/hero-81.jpg\" alt=\"\ub2e4\uc591\ud55c \uc778\ub371\uc2a4 \uc885\ub958\uc640 \ub370\uc774\ud130 \ubd84\ud3ec\uc5d0 \ub530\ub978 \uc801\ud569\uc131 \ub3c4\uc2dd\">\n<\/header>\n\n<div class=\"container\">\n<article>\n\n<p>\uc778\ub371\uc2a4\ub294 &#8220;\ucc45 \ub4a4\uc758 \uc0c9\uc778&#8221; \u2014 \uc5c6\uc73c\uba74 \ucc98\uc74c\ubd80\ud130 \ub05d\uae4c\uc9c0 \ub2e4 \uc77d\uc5b4\uc57c \ud558\uc9c0\ub9cc, \uc788\uc73c\uba74 \ub2e8\uc228\uc5d0 \ud398\uc774\uc9c0\ub97c \ud3bc\uce69\ub2c8\ub2e4. \ub2e4\ub9cc \uc885\ub958\uc640 \uc0ac\uc6a9 \ud328\ud134\uc774 \ub9de\uc544\uc57c \ud6a8\ub825. 16\ud3b8\uc740 PG \uc758 5\uac00\uc9c0 \uc8fc\uc694 \uc778\ub371\uc2a4, \uceec\ub7fc \uc21c\uc11c, partial\/covering \uc778\ub371\uc2a4, \uadf8\ub9ac\uace0 &#8220;\uc5b4\ub514\uc5d0 \uc778\ub371\uc2a4\ub97c \ub458\uae4c&#8221; \uc758 \uac00\uc774\ub4dc.<\/p>\n\n<h2>5\uac00\uc9c0 \uc778\ub371\uc2a4 \uc885\ub958<\/h2>\n\n<div class=\"tablewrap\">\n<table>\n  <thead>\n    <tr><th>\uc885\ub958<\/th><th>\uc801\ud569\ud55c \ub370\uc774\ud130<\/th><th>\uc8fc\uc694 \uc5f0\uc0b0\uc790<\/th><\/tr>\n  <\/thead>\n  <tbody>\n    <tr><td data-label=\"\">B-Tree (\uae30\ubcf8)<\/td><td data-label=\"\">\uc815\ub82c \uac00\ub2a5\ud55c \uac12 (\uc22b\uc790\u00b7\ubb38\uc790\u00b7\ub0a0\uc9dc)<\/td><td data-label=\"\">= &lt; &gt; BETWEEN<\/td><\/tr>\n    <tr><td data-label=\"\">Hash<\/td><td data-label=\"\">= \ub9cc \ud544\uc694\ud55c \uac12<\/td><td data-label=\"\">= \ub9cc<\/td><\/tr>\n    <tr><td data-label=\"\">GIN<\/td><td data-label=\"\">&#8220;\uc5ec\ub7ec \uac12 \ud3ec\ud568&#8221; (\ubc30\uc5f4\u00b7jsonb\u00b7tsvector)<\/td><td data-label=\"\">@&gt; ?  &amp;@@<\/td><\/tr>\n    <tr><td data-label=\"\">GiST<\/td><td data-label=\"\">\uae30\ud558\u00b7\ubc94\uc704\u00b7near \uac80\uc0c9<\/td><td data-label=\"\">&amp;&amp; &lt;-&gt;<\/td><\/tr>\n    <tr><td data-label=\"\">BRIN<\/td><td data-label=\"\">\ubb3c\ub9ac\uc801\uc73c\ub85c \uc815\ub82c\ub41c \ud070 \ud14c\uc774\ube14 (\ub85c\uadf8\u00b7\uc2dc\uacc4\uc5f4)<\/td><td data-label=\"\">= &lt; &gt;<\/td><\/tr>\n  <\/tbody>\n<\/table>\n<\/div>\n\n<div class=\"databox\">\n  <p><strong>\ud55c \uc904 \uacb0\uc815.<\/strong> 90% \uc758 \uc778\ub371\uc2a4\ub294 <strong>B-Tree<\/strong>. JSON\u00b7\ud0dc\uadf8\u00b7\uc804\ubb38 \uac80\uc0c9\uc740 <strong>GIN<\/strong>. \ucd94\uac00\ub9cc \ub418\ub294 \uac70\ub300\ud55c \ub85c\uadf8\u00b7\uc2dc\uacc4\uc5f4\uc740 <strong>BRIN<\/strong>. \uadf8 \uc678\ub294 \uac70\uc758 \uc548 \uc500.<\/p>\n<\/div>\n\n<h2>B-Tree \u2014 \uae30\ubcf8\ud615<\/h2>\n\n<pre><code>-- \uae30\ubcf8\nCREATE INDEX ix_users_email ON users (email);\n\n-- UNIQUE (\uc81c\uc57d + \uc778\ub371\uc2a4)\nCREATE UNIQUE INDEX uq_users_email ON users (email);\n\n-- \uc815\ub82c \ubc29\ud5a5\nCREATE INDEX ix_posts_created ON posts (created_at DESC);\n-- ORDER BY created_at DESC \uc778 \ucffc\ub9ac\uc5d0\uc11c \ub354 \ud6a8\uc728\n\n-- NULLS \uc21c\uc11c\nCREATE INDEX ix_users_phone ON users (phone NULLS LAST);<\/code><\/pre>\n\n<h2>multi-column \uc778\ub371\uc2a4 \u2014 \uceec\ub7fc \uc21c\uc11c\uac00 \ud575\uc2ec<\/h2>\n\n<pre><code>-- \uc790\uc8fc \uac19\uc774 \uc4f0\ub294 \uceec\ub7fc\nCREATE INDEX ix_orders_user_date ON orders (user_id, created_at);\n\n-- \uc5b4\ub5a4 \ucffc\ub9ac\uc5d0 \ub4e3\ub098?\nSELECT * FROM orders WHERE user_id = 5;                              -- \u2705 \ub4e3\uc74c\nSELECT * FROM orders WHERE user_id = 5 AND created_at &gt; '2026-01-01'; -- \u2705 \ucd5c\uc801\nSELECT * FROM orders WHERE created_at &gt; '2026-01-01';                -- \u274c \uc548 \ub4e3\uc74c\n-- \uccab \uceec\ub7fc\uc774 WHERE \uc5d0 \uc5c6\uc73c\uba74 \uc778\ub371\uc2a4 \ubabb \uc500 (B-Tree \uc758 \uae30\ubcf8 \ub3d9\uc791)<\/code><\/pre>\n\n<div class=\"warnbox\">\n  <p><strong>\uceec\ub7fc \uc21c\uc11c \u2014 \uce74\ub514\ub110\ub9ac\ud2f0 \ub192\uc740 \uac70 \uba3c\uc800? \uc544\ub2c8\ub2e4.<\/strong> \uac00\uc7a5 \uc790\uc8fc \uc0ac\uc6a9\ub418\ub294 \uceec\ub7fc, \ub610\ub294 <strong>\ub4f1\ud638 \ube44\uad50\uac00 \uba3c\uc800, \ubc94\uc704 \ube44\uad50\uac00 \ub4a4<\/strong> \uac00 \uc815\uc11d. (user_id=5 AND created_at &gt; &#8230;) \ud328\ud134\uc5d4 (user_id, created_at) \uc21c\uc11c.<\/p>\n<\/div>\n\n<h2>partial index \u2014 \uc77c\ubd80\ub9cc<\/h2>\n\n<pre><code>-- \"\ud65c\uc131 \uc0ac\uc6a9\uc790\" \ub9cc \uc778\ub371\uc2a4 \u2192 \ub354 \uc791\uace0 \ube60\ub984\nCREATE INDEX ix_users_active_email ON users (email)\nWHERE active = true;\n\n-- \ucffc\ub9ac\ub3c4 \uac19\uc740 \uc870\uac74\uc774\uc5b4\uc57c \uc0ac\uc6a9\ub428\nSELECT * FROM users WHERE email = 'x@y.com' AND active = true;   -- \u2705\n\n-- \uc791\uc5c5 \ud050 \ud328\ud134 (15\ud3b8 SKIP LOCKED \uc640 \ud568\uaed8)\nCREATE INDEX ix_jobs_pending ON jobs (created_at)\nWHERE status = 'pending';\n-- 'done' \ud589\uc740 \uc778\ub371\uc2a4\uc5d0 \uc5c6\uc74c \u2192 \uc778\ub371\uc2a4 \ud06c\uae30 \uc548\uc815\uc801<\/code><\/pre>\n\n<h2>covering index (INCLUDE) \u2014 \uc778\ub371\uc2a4\ub9cc\uc73c\ub85c \uc751\ub2f5<\/h2>\n\n<pre><code>-- \uc790\uc8fc select \ud558\ub294 \uceec\ub7fc\uc744 INCLUDE \ub85c\nCREATE INDEX ix_users_email_inc ON users (email) INCLUDE (name, created_at);\n\n-- \uc778\ub371\uc2a4 \uc548\uc5d0 name\u00b7created_at \uac00 \ud568\uaed8 \ub4e4\uc5b4\uc788\uc73c\ub2c8\n-- \ud14c\uc774\ube14 \ubcf8\ubb38 \uc548 \uac00\ub3c4 \uc751\ub2f5 \uac00\ub2a5 \u2192 \"Index Only Scan\"\nSELECT name, created_at FROM users WHERE email = 'x@y.com';<\/code><\/pre>\n\n<h2>\ud45c\ud604\uc2dd \uc778\ub371\uc2a4 \u2014 \uacc4\uc0b0\ub41c \uac12\uc5d0<\/h2>\n\n<pre><code>-- lower(email) \ub85c \uc790\uc8fc \ube44\uad50\ud55c\ub2e4\uba74\nCREATE INDEX ix_users_email_lower ON users ((lower(email)));\n\n-- \ucffc\ub9ac\uc5d0 \uac19\uc740 \ud45c\ud604\uc2dd \ud544\uc694\nSELECT * FROM users WHERE lower(email) = lower($1);   -- \u2705\n\n-- json \ud0a4\nCREATE INDEX ix_products_color ON products ((meta-&gt;&gt;'color'));<\/code><\/pre>\n\n<h2>GIN \u2014 jsonb\u00b7\ubc30\uc5f4\u00b7\uc804\ubb38 \uac80\uc0c9<\/h2>\n\n<pre><code>-- jsonb\nCREATE INDEX ix_products_meta ON products USING GIN (meta);\nSELECT * FROM products WHERE meta @&gt; '{\"color\":\"red\"}';   -- \ube60\ub984\n\n-- \ubc30\uc5f4\nCREATE INDEX ix_posts_tags ON posts USING GIN (tags);\nSELECT * FROM posts WHERE 'sale' = ANY(tags);\n\n-- \uc804\ubb38 \uac80\uc0c9 (tsvector)\nCREATE INDEX ix_articles_search ON articles USING GIN (to_tsvector('simple', title));\nSELECT * FROM articles WHERE to_tsvector('simple', title) @@ to_tsquery('PostgreSQL');\n\n-- pg_trgm \u2014 LIKE '%xxx%' \uac00\uc18d (\ud655\uc7a5 \ud544\uc694)\nCREATE EXTENSION pg_trgm;\nCREATE INDEX ix_users_name_trgm ON users USING GIN (name gin_trgm_ops);\nSELECT * FROM users WHERE name ILIKE '%\uc900\uc131%';   -- \uc778\ub371\uc2a4 \uc0ac\uc6a9!<\/code><\/pre>\n\n<h2>BRIN \u2014 \uac70\ub300\ud55c \uc2dc\uacc4\uc5f4\uc758 \uac00\ubcbc\uc6b4 \uc778\ub371\uc2a4<\/h2>\n\n<pre><code>-- \ub85c\uadf8 \ud14c\uc774\ube14 (\uc218\uc5b5 \ud589, created_at \uc21c\uc73c\ub85c \ub204\uc801)\nCREATE INDEX ix_logs_created_brin ON logs USING BRIN (created_at);\n\n-- BRIN \uc740 B-Tree \ub300\ube44\n-- \u00b7 \uc778\ub371\uc2a4 \ud06c\uae30 1\/1000 (\uc608: 1GB \u2192 1MB)\n-- \u00b7 \uc870\ud68c\ub294 \uc57d\uac04 \ub290\ub9bc\n-- \u00b7 \uc4f0\uae30 \ubd80\ud558 \uc5c6\uc74c\nSELECT * FROM logs WHERE created_at &gt; CURRENT_DATE - INTERVAL '1 day';<\/code><\/pre>\n\n<h2>\uc778\ub371\uc2a4 \ub9cc\ub4e4\uae30\u00b7\uc0ad\uc81c \u2014 \uc6b4\uc601 \ud658\uacbd \uc8fc\uc758<\/h2>\n\n<pre><code>-- \uc77c\ubc18 CREATE INDEX \u2014 \ud14c\uc774\ube14\uc5d0 SHARE \ub77d (INSERT\/UPDATE \ub3d9\uc548 \ucc28\ub2e8)\nCREATE INDEX ix_x ON big_table (col);\n\n-- \uc548\uc804 \u2014 \ub77d \uc548 \uc7a1\uc74c (\ub290\ub9ac\uc9c0\ub9cc \uc6b4\uc601 OK)\nCREATE INDEX CONCURRENTLY ix_x ON big_table (col);\n\n-- \uc0ad\uc81c\ub3c4\nDROP INDEX CONCURRENTLY ix_x;\n\n-- \uc778\ub371\uc2a4 \ub2e4\uc2dc \ub9cc\ub4e4\uae30 (bloat \uc815\ub9ac)\nREINDEX INDEX CONCURRENTLY ix_x;<\/code><\/pre>\n\n<div class=\"warnbox\">\n  <p><strong>\uc6b4\uc601 DB \uc5d0\uc11c\ub294 \ud56d\uc0c1 CONCURRENTLY.<\/strong> \uc77c\ubc18 CREATE INDEX \ub294 \ud070 \ud14c\uc774\ube14\uc5d0\uc11c \uc218 \ubd84 \ub3d9\uc548 \uc4f0\uae30\ub97c \ub9c9\uc2b5\ub2c8\ub2e4. CONCURRENTLY \ub294 \uc2dc\uac04\uc774 \uc880 \ub354 \uac78\ub9ac\uc9c0\ub9cc \ub77d\uc774 \uac00\ubcbc\uc6c0.<\/p>\n<\/div>\n\n<h2>\uc778\ub371\uc2a4 \uc0ac\uc6a9 \ud655\uc778 \u2014 EXPLAIN<\/h2>\n\n<pre><code>EXPLAIN SELECT * FROM users WHERE email = 'x@y.com';\n\n-- \"Index Scan using ix_users_email\" \u2192 \uc778\ub371\uc2a4 \uc0ac\uc6a9\ub428\n-- \"Seq Scan on users\" \u2192 \uc778\ub371\uc2a4 \ubb34\uc2dc\ub428 (\ud14c\uc774\ube14 \ud480\uc2a4\uce94)\n\n-- \uc2e4\uc81c \uc2dc\uac04\uae4c\uc9c0\nEXPLAIN ANALYZE SELECT * FROM users WHERE email = 'x@y.com';\n-- \"actual time=0.012..0.014\" \uac19\uc740 \uc2e4\uc81c \uce21\uc815<\/code><\/pre>\n\n<h2>\uc778\ub371\uc2a4 \ud1b5\uacc4 \u2014 \uc548 \uc4f0\ub294 \uc778\ub371\uc2a4 \ucc3e\uae30<\/h2>\n\n<pre><code>-- \uac01 \uc778\ub371\uc2a4\uac00 \uc5bc\ub9c8\ub098 \uc790\uc8fc \uc4f0\uc600\ub098\nSELECT schemaname, relname, indexrelname,\n       idx_scan, idx_tup_read, idx_tup_fetch\nFROM   pg_stat_user_indexes\nORDER BY idx_scan;\n-- idx_scan = 0 \uc778 \uc778\ub371\uc2a4\ub294 \ud55c \ubc88\ub3c4 \uc548 \uc4f0\uc784 \u2014 \uc81c\uac70 \ud6c4\ubcf4\n\n-- \uc778\ub371\uc2a4 \ud06c\uae30\nSELECT relname, pg_size_pretty(pg_relation_size(indexrelid)) AS size\nFROM   pg_stat_user_indexes\nORDER BY pg_relation_size(indexrelid) DESC;<\/code><\/pre>\n\n<h2>\uc778\ub371\uc2a4\uc758 \ube44\uc6a9<\/h2>\n\n<div class=\"warnbox\">\n  <p><strong>\uc778\ub371\uc2a4\ub294 \uacf5\uc9dc\uac00 \uc544\ub2d9\ub2c8\ub2e4.<\/strong><\/p>\n  <p>\u00b7 <strong>\uc800\uc7a5 \uacf5\uac04<\/strong> \u2014 \ud070 \ud14c\uc774\ube14\uc758 \uc778\ub371\uc2a4\ub294 GB \ub2e8\uc704.<\/p>\n  <p>\u00b7 <strong>\uc4f0\uae30 \uc18d\ub3c4<\/strong> \u2014 INSERT\/UPDATE \ub9c8\ub2e4 \uc778\ub371\uc2a4\ub3c4 \uac31\uc2e0.<\/p>\n  <p>\u00b7 <strong>\uc720\uc9c0\ubcf4\uc218<\/strong> \u2014 VACUUM\u00b7REINDEX \ubd80\ud558.<\/p>\n  <p>&#8220;\uac80\uc0c9\ub418\ub294&#8221; \uceec\ub7fc\uc5d0\ub9cc, \uc815\ub9d0 \ud544\uc694\ud55c \ub9cc\ud07c\ub9cc.<\/p>\n<\/div>\n\n<h2>\ud55c \uc904 \uac00\uc774\ub4dc<\/h2>\n\n<ul>\n  <li>FK\u00b7\uc790\uc8fc WHERE \uc5d0 \ub098\uc624\ub294 \uceec\ub7fc \u2192 B-Tree<\/li>\n  <li>UNIQUE \uc81c\uc57d\uc740 \uc790\ub3d9\uc73c\ub85c \uc778\ub371\uc2a4 (UNIQUE \ub3c4)<\/li>\n  <li>(a, b) \uc778\ub371\uc2a4\ub294 a \ub2e8\ub3c5 \ucffc\ub9ac\uc5d0\ub3c4 \uc791\ub3d9, b \ub2e8\ub3c5\uc740 \uc544\ub2d8<\/li>\n  <li>jsonb \/ \ubc30\uc5f4 \/ \uc804\ubb38 \uac80\uc0c9 \u2192 GIN<\/li>\n  <li>\ub85c\uadf8\u00b7\uc2dc\uacc4\uc5f4 (\uc218\uc5b5 \ud589) \u2192 BRIN<\/li>\n  <li>&#8220;\ud65c\uc131\u00b7\ubbf8\ubc1c\uc1a1&#8221; \uac19\uc740 \uc881\uc740 \ubd80\ubd84 \u2192 partial<\/li>\n  <li>SELECT \uceec\ub7fc\uc774 \uc801\uace0 \uc790\uc8fc \u2192 INCLUDE \ub85c covering<\/li>\n  <li>\uc6b4\uc601 DB: <strong>\ud56d\uc0c1 CONCURRENTLY<\/strong><\/li>\n<\/ul>\n\n<div class=\"cta\">\n  <h3>17\ud3b8 \u2014 EXPLAIN \uc73c\ub85c \uc2e4\ud589 \uacc4\ud68d \uc77d\uae30<\/h3>\n  <p>Seq Scan vs Index Scan vs Bitmap, \uc608\uc0c1 vs \uc2e4\uc81c \ube44\uc6a9.<\/p>\n<\/div>\n\n<div class=\"series-nav\">\n  <strong>\ud83d\udcda PostgreSQL \ubc30\uc6b0\uae30 \uad50\uc7ac<\/strong><br>\n  \uc774\uc804: 15\ud3b8 \ub77d \u00b7 \ud604\uc7ac: <strong>16\ud3b8 (\uc911\uae09)<\/strong> \u00b7 \ub2e4\uc74c \u2192 17\ud3b8 EXPLAIN \u00b7 \uc9c4\ud589: <strong>16\/24<\/strong>\n<\/div>\n\n<\/article>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\uc778\ub371\uc2a4 5\uc885\uacfc multi-column\u00b7partial\u00b7covering \uc804\ub7b5. 24\ud3b8 \uad50\uc7ac 16\ud3b8.<\/p>\n","protected":false},"author":1,"featured_media":302,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-510","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgresql"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/posts\/510","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/comments?post=510"}],"version-history":[{"count":0,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/posts\/510\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/media\/302"}],"wp:attachment":[{"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/media?parent=510"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/categories?post=510"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/tags?post=510"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}