{"id":521,"date":"2026-05-17T07:04:52","date_gmt":"2026-05-16T23:04:52","guid":{"rendered":"https:\/\/junai.ai\/blog\/pg-partitioning-22\/"},"modified":"2026-05-17T07:04:52","modified_gmt":"2026-05-16T23:04:52","slug":"pg-partitioning-22","status":"publish","type":"post","link":"https:\/\/junai.ai\/blog\/pg-partitioning-22\/","title":{"rendered":"\ud30c\ud2f0\uc154\ub2dd \u2014 RANGE\u00b7LIST\u00b7HASH (\uace0\uae09 22\ud3b8)"},"content":{"rendered":"\n<!-- WordPress REST API \ubc1c\ud589\uc6a9 HTML (\uc790\ub3d9 \uc0dd\uc131) -->\n<!-- WP-FEATURED-MEDIA-ID: 332 -->\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 22\ud3b8 \/ 24\ud3b8<\/span>\n  <h1>\ud30c\ud2f0\uc154\ub2dd \u2014 RANGE\u00b7LIST\u00b7HASH<\/h1>\n  <p class=\"sub\">\ud070 \ud14c\uc774\ube14\uc744 \uc798\uac8c. \uc2dc\uacc4\uc5f4\u00b7\ub2e4\uad6d\uac00\u00b7\ud574\uc2dc \ubd84\uc0b0\uc758 \ud45c\uc900.<\/p>\n  <div class=\"meta\"><span>\uace0\uae09<\/span><span>\uc77d\ub294 \uc2dc\uac04 7\ubd84<\/span><span>2026-05-17<\/span><\/div>\n  <img decoding=\"async\" src=\"https:\/\/junai.ai\/blog\/wp-content\/uploads\/2026\/05\/hero-99.jpg\" alt=\"\ud070 \ud14c\uc774\ube14\uc774 \ud30c\ud2f0\uc158\uc73c\ub85c \ubd84\ud560\ub418\uc5b4 \ucffc\ub9ac\uac00 \uc77c\ubd80\ub9cc \uc2a4\uce94\ud558\ub294 \ub3c4\uc2dd\">\n<\/header>\n\n<div class=\"container\">\n<article>\n\n<p>1\uc5b5 \ud589 \ud14c\uc774\ube14\uc5d0\uc11c &#8220;\uc774\ubc88 \ub2ec \ub370\uc774\ud130\ub9cc&#8221; \uc744 \ub9e4\ubc88 \uac80\uc0c9\ud558\uba74 \uc778\ub371\uc2a4\uac00 \uc788\uc5b4\ub3c4 \ubb34\uac81\uc2b5\ub2c8\ub2e4. <strong>\ud30c\ud2f0\uc154\ub2dd<\/strong>\uc740 \ud14c\uc774\ube14\uc744 \ubb3c\ub9ac\uc801\uc73c\ub85c \uc5ec\ub7ec \uc870\uac01\uc73c\ub85c \ub098\ub204\uc5b4, \ucffc\ub9ac\uac00 \ud544\uc694\ud55c \uc870\uac01\ub9cc \ub9cc\uc9c0\uac8c \ud569\ub2c8\ub2e4. 22\ud3b8\uc740 PG \uc758 3\uac00\uc9c0 \ud30c\ud2f0\uc158 \ubc29\uc2dd\uacfc \uc2dc\uacc4\uc5f4 \ub370\uc774\ud130 \ud328\ud134.<\/p>\n\n<h2>\uc65c \ud30c\ud2f0\uc154\ub2dd? \u2014 4\uac00\uc9c0 \uc774\uc720<\/h2>\n\n<ul>\n  <li><strong>\ucffc\ub9ac \uc131\ub2a5<\/strong> \u2014 \ud544\uc694\ud55c \ud30c\ud2f0\uc158\ub9cc \uc2a4\uce94(partition pruning).<\/li>\n  <li><strong>\uc720\uc9c0\ubcf4\uc218<\/strong> \u2014 \uc61b \ud30c\ud2f0\uc158 \ud1b5\uc9f8\ub85c DROP (1\ucd08). DELETE \ubcf4\ub2e4 \uc555\ub3c4\uc801.<\/li>\n  <li><strong>\uc778\ub371\uc2a4 \ud06c\uae30<\/strong> \u2014 \ud30c\ud2f0\uc158\ubcc4 \uc778\ub371\uc2a4\uac00 \uc791\uc544 \uce90\uc2dc \ud6a8\uc728 \u2191.<\/li>\n  <li><strong>\ubcd1\ub82c \ucc98\ub9ac<\/strong> \u2014 \ud30c\ud2f0\uc158 \ub2e8\uc704\ub85c \ubcd1\ub82c \uc2a4\uce94\u00b7VACUUM.<\/li>\n<\/ul>\n\n<h2>3\uac00\uc9c0 \ud30c\ud2f0\uc158 \ubc29\uc2dd<\/h2>\n\n<div class=\"tablewrap\">\n<table>\n  <thead>\n    <tr><th>\ubc29\uc2dd<\/th><th>\ubd84\ud560 \uae30\uc900<\/th><th>\uc8fc \uc6a9\ub3c4<\/th><\/tr>\n  <\/thead>\n  <tbody>\n    <tr><td data-label=\"\">RANGE<\/td><td data-label=\"\">\ubc94\uc704 (\ub0a0\uc9dc\u00b7\uc22b\uc790 \uad6c\uac04)<\/td><td data-label=\"\">\uc2dc\uacc4\uc5f4\u00b7\ub85c\uadf8<\/td><\/tr>\n    <tr><td data-label=\"\">LIST<\/td><td data-label=\"\">\uac12 \uc9d1\ud569 (\uad6d\uac00\u00b7\uc9c0\uc5ed\u00b7\uce74\ud14c\uace0\ub9ac)<\/td><td data-label=\"\">\uba40\ud2f0 \ud14c\ub10c\ud2b8\u00b7\ub2e4\uad6d\uac00<\/td><\/tr>\n    <tr><td data-label=\"\">HASH<\/td><td data-label=\"\">\ud574\uc2dc (\uade0\ub4f1 \ubd84\uc0b0)<\/td><td data-label=\"\">\ud589 \ubd84\uc0b0 (\ud2b9\uc815 \ud0a4 \ud56b\uc2a4\ud31f \uc5c6\uc74c)<\/td><\/tr>\n  <\/tbody>\n<\/table>\n<\/div>\n\n<h2>RANGE \u2014 \uc6d4\ubcc4 \uc2dc\uacc4\uc5f4<\/h2>\n\n<pre><code>-- 1) \ud30c\ud2f0\uc158 \ubd80\ubaa8 \ud14c\uc774\ube14\nCREATE TABLE events (\n  id          BIGSERIAL,\n  user_id     BIGINT,\n  event_type  TEXT,\n  payload     JSONB,\n  created_at  TIMESTAMPTZ NOT NULL,\n  PRIMARY KEY (id, created_at)         -- \ud30c\ud2f0\uc158 \ud0a4\ub97c PK \uc5d0 \ud3ec\ud568 \ud544\uc218\n) PARTITION BY RANGE (created_at);\n\n-- 2) \uc6d4\ubcc4 \ud30c\ud2f0\uc158\nCREATE TABLE events_2026_01 PARTITION OF events\n  FOR VALUES FROM ('2026-01-01') TO ('2026-02-01');\n\nCREATE TABLE events_2026_02 PARTITION OF events\n  FOR VALUES FROM ('2026-02-01') TO ('2026-03-01');\n\nCREATE TABLE events_2026_03 PARTITION OF events\n  FOR VALUES FROM ('2026-03-01') TO ('2026-04-01');\n\n-- INSERT \ub294 \ubd80\ubaa8\uc5d0 \u2014 Postgres \uac00 \uc790\ub3d9\uc73c\ub85c \uc54c\ub9de\uc740 \ud30c\ud2f0\uc158\uc5d0\nINSERT INTO events (...) VALUES (...);\n\n-- SELECT \ub3c4 \ubd80\ubaa8\uc5d0\nSELECT * FROM events WHERE created_at &gt;= '2026-02-15';\n-- \u2192 events_2026_02 \uc640 \uadf8 \uc774\ud6c4\ub9cc \uc2a4\uce94 (partition pruning)<\/code><\/pre>\n\n<h2>LIST \u2014 \uc9c0\uc5ed\ubcc4<\/h2>\n\n<pre><code>CREATE TABLE orders_regional (\n  id      BIGSERIAL,\n  region  TEXT NOT NULL,\n  total   NUMERIC,\n  PRIMARY KEY (id, region)\n) PARTITION BY LIST (region);\n\nCREATE TABLE orders_kr PARTITION OF orders_regional FOR VALUES IN ('KR');\nCREATE TABLE orders_jp PARTITION OF orders_regional FOR VALUES IN ('JP');\nCREATE TABLE orders_us PARTITION OF orders_regional FOR VALUES IN ('US', 'CA');\n\n-- \ub098\uba38\uc9c0\nCREATE TABLE orders_other PARTITION OF orders_regional DEFAULT;<\/code><\/pre>\n\n<h2>HASH \u2014 \uade0\ub4f1 \ubd84\uc0b0<\/h2>\n\n<pre><code>CREATE TABLE users_h (\n  id    BIGINT NOT NULL,\n  name  TEXT,\n  PRIMARY KEY (id)\n) PARTITION BY HASH (id);\n\n-- 4\uac1c \ud30c\ud2f0\uc158 (0, 1, 2, 3)\nCREATE TABLE users_h_0 PARTITION OF users_h FOR VALUES WITH (MODULUS 4, REMAINDER 0);\nCREATE TABLE users_h_1 PARTITION OF users_h FOR VALUES WITH (MODULUS 4, REMAINDER 1);\nCREATE TABLE users_h_2 PARTITION OF users_h FOR VALUES WITH (MODULUS 4, REMAINDER 2);\nCREATE TABLE users_h_3 PARTITION OF users_h FOR VALUES WITH (MODULUS 4, REMAINDER 3);<\/code><\/pre>\n\n<div class=\"databox\">\n  <p><strong>\uc5b8\uc81c HASH?<\/strong> \uc2dc\uac04\u00b7\uac12 \ubd84\ud3ec \uc5c6\uc774 \ubb34\uc870\uac74 \uade0\ub4f1 \ubd84\uc0b0\uc774 \ud544\uc694\ud560 \ub54c. \ub2e4\ub9cc &#8220;\ud2b9\uc815 user_id \ub370\uc774\ud130\ub9cc&#8221; \uac19\uc740 \ucffc\ub9ac\ub3c4 \ud30c\ud2f0\uc158\uc744 \ud558\ub098\ub9cc \ub9cc\uc9c0\uac8c \ub428 \u2014 id \ubd84\ud3ec\uac00 \uace8\uace0\ub8e8\uba74 \ud6a8\uacfc\uc801. \ub2e8\uc810: \ubc94\uc704 \ucffc\ub9ac\ub294 \ubaa8\ub4e0 \ud30c\ud2f0\uc158 \uc2a4\uce94.<\/p>\n<\/div>\n\n<h2>\ud30c\ud2f0\uc158 \uc778\ub371\uc2a4 \u2014 \ubd80\ubaa8\uc5d0 \ub9cc\ub4e4\uba74 \ubaa8\ub450 \uc0c1\uc18d<\/h2>\n\n<pre><code>-- \ubd80\ubaa8\uc5d0 \uc778\ub371\uc2a4 \u2192 \ubaa8\ub4e0 \ud30c\ud2f0\uc158\uc5d0 \uc790\ub3d9\nCREATE INDEX ix_events_user ON events (user_id);\n\n-- \ub610\ub294 \ud30c\ud2f0\uc158\ubcc4 \uac1c\ubcc4 \uc778\ub371\uc2a4\nCREATE INDEX ix_events_2026_01_user ON events_2026_01 (user_id);\n\n-- UNIQUE \uc81c\uc57d\uc740 \ud30c\ud2f0\uc158 \ud0a4\ub97c \ud3ec\ud568\ud574\uc57c \ud568\nCREATE UNIQUE INDEX uq_events_id ON events (id, created_at);<\/code><\/pre>\n\n<h2>partition pruning \ud655\uc778 \u2014 EXPLAIN<\/h2>\n\n<pre><code>EXPLAIN SELECT * FROM events WHERE created_at &gt;= '2026-03-01';\n\n-- \uacb0\uacfc\n-- Append\n--   -&gt; Seq Scan on events_2026_03   \u2190 \uc774\uac83\ub9cc!\n-- (\ub2e4\ub978 \ud30c\ud2f0\uc158\uc740 \uc548 \ub098\ud0c0\ub0a8 \u2192 pruning \uc131\uacf5)<\/code><\/pre>\n\n<h2>\ud30c\ud2f0\uc158 \uad00\ub9ac \u2014 \ucd94\uac00\u00b7\uc0ad\uc81c<\/h2>\n\n<pre><code>-- \uc0c8 \ub2ec \ud30c\ud2f0\uc158 \ucd94\uac00\nCREATE TABLE events_2026_04 PARTITION OF events\n  FOR VALUES FROM ('2026-04-01') TO ('2026-05-01');\n\n-- \uc61b \ud30c\ud2f0\uc158 \ubd84\ub9ac (\ubc31\uc5c5\u00b7\uc544\uce74\uc774\ube0c\uc6a9)\nALTER TABLE events DETACH PARTITION events_2025_01;\n-- \ubd84\ub9ac\ub41c \ud14c\uc774\ube14\uc740 \uc77c\ubc18 \ud14c\uc774\ube14 \u2014 \ubc31\uc5c5 \ud6c4 DROP\n\n-- \ub610\ub294 \uc989\uc2dc \uc0ad\uc81c\nDROP TABLE events_2025_01;   -- 1\ucd08 (DELETE \uc640 \ube44\uad50 \ubd88\uac00)<\/code><\/pre>\n\n<h2>pg_partman \u2014 \ud30c\ud2f0\uc158 \uc790\ub3d9 \uad00\ub9ac<\/h2>\n\n<pre><code>CREATE EXTENSION pg_partman;\n\n-- \uc790\ub3d9\uc73c\ub85c \ub9e4\uc6d4 \uc0c8 \ud30c\ud2f0\uc158 \ub9cc\ub4e4\uace0 \uc61b \uac83 \uc815\ub9ac\nSELECT partman.create_parent(\n  p_parent_table  := 'public.events',\n  p_control       := 'created_at',\n  p_type          := 'range',\n  p_interval      := '1 month',\n  p_premake       := 4              -- 4\uac1c\uc6d4 \ubbf8\ub9ac \ub9cc\ub4e4\uae30\n);\n\n-- cron \ub610\ub294 pg_cron \uc73c\ub85c \uc8fc\uae30 \uc2e4\ud589\nSELECT partman.run_maintenance();   -- \uc0c8 \ud30c\ud2f0\uc158 + \uc61b \uac83 \uc815\ub9ac<\/code><\/pre>\n\n<div class=\"databox\">\n  <p><strong>pg_partman \uc758 \uac00\uce58.<\/strong> \uc218\ub3d9\uc73c\ub85c \ub9e4\ub2ec \ud30c\ud2f0\uc158 \ub9cc\ub4e4\uae30 \u2192 \uc78a\uc5b4\ubc84\ub9ac\uba74 \uc0ac\uace0. pg_partman \uc774 \uc77c\uc815 \uc8fc\uae30\ub85c \ubbf8\ub9ac \ub9cc\ub4e4\uace0 \uc61b \uac83 \ubcf4\uad00(detach \ub610\ub294 drop). \uc2dc\uacc4\uc5f4 \ub370\uc774\ud130\uc5d0\ub294 \uac70\uc758 \ud544\uc218.<\/p>\n<\/div>\n\n<h2>\uc2e4\uc804 \u2014 \uc2dc\uacc4\uc5f4 \ub370\uc774\ud130 \ud328\ud134<\/h2>\n\n<pre><code>-- 1) \uc6d4\ubcc4 RANGE \ud30c\ud2f0\uc158\nCREATE TABLE metrics (\n  ts      TIMESTAMPTZ NOT NULL,\n  device  TEXT NOT NULL,\n  value   DOUBLE PRECISION\n) PARTITION BY RANGE (ts);\n\n-- 2) BRIN \uc778\ub371\uc2a4 (16\ud3b8 \u2014 \uc2dc\uacc4\uc5f4\uc5d0 \ucd5c\uc801)\nCREATE INDEX ix_metrics_ts ON metrics USING BRIN (ts);\n\n-- 3) pg_partman \uc790\ub3d9 \uad00\ub9ac\n\n-- 4) 90\uc77c \ubcf4\uad00 \ud6c4 \uc790\ub3d9 \uc0ad\uc81c\nSELECT partman.create_parent(\n  ...,\n  p_premake := 3,\n  p_retention := '90 days',\n  p_retention_keep_table := false   -- detach \uac00 \uc544\ub2c8\ub77c drop\n);<\/code><\/pre>\n\n<h2>\uc81c\uc57d \u2014 \uc54c\uc544\ub450\uba74 \uc88b\uc740 5\uac00\uc9c0<\/h2>\n\n<div class=\"warnbox\">\n  <p><strong>1. \ud30c\ud2f0\uc158 \ud0a4\ub294 PK\u00b7UNIQUE \uc5d0 \ud3ec\ud568<\/strong>\uc774 \ud544\uc218. UNIQUE \uac80\uc0ac\ub97c \ud30c\ud2f0\uc158 \uc548\uc5d0\uc11c\ub9cc \ud558\ub2c8\uae4c.<\/p>\n  <p><strong>2. FK \uac00 \ud30c\ud2f0\uc158 \ud14c\uc774\ube14\uc744 \uac00\ub9ac\ud0a4\ub294 \uac83<\/strong> \uc740 \uac00\ub2a5\ud558\uc9c0\ub9cc, \ud30c\ud2f0\uc158 \ud14c\uc774\ube14\uc5d0\uc11c \ub2e4\ub978 \ud14c\uc774\ube14\ub85c FK \ub294 PG 11+ \ubd80\ud130.<\/p>\n  <p><strong>3. ALTER TABLE \uc758 \uc77c\ubd80 \uba85\ub839\uc740 \ud30c\ud2f0\uc158\ub9c8\ub2e4<\/strong>. \ubd80\ubaa8 \u2192 \uc790\uc2dd \uc77c\uad04 \uc801\uc6a9\uc740 \uc81c\ud55c\uc801.<\/p>\n  <p><strong>4. \ub108\ubb34 \uc791\uc740 \ud30c\ud2f0\uc158<\/strong>(\uc218\ub9cc \ud589) \uc740 \uc624\ubc84\ud5e4\ub4dc\ub9cc \ud07c. \ubcf4\ud1b5 100\ub9cc~1\uc5b5 \ud589 \uc815\ub3c4 \ub2e8\uc704.<\/p>\n  <p><strong>5. \ub108\ubb34 \ub9ce\uc740 \ud30c\ud2f0\uc158<\/strong>(\uc218\ucc9c \uac1c) \uc740 \ud50c\ub798\ub2dd \ube44\uc6a9 \u2191. <code>enable_partition_pruning = on<\/code>\u00b7<code>partition_prune_skip<\/code> \ud6a8\uacfc \ud655\uc778.<\/p>\n<\/div>\n\n<div class=\"cta\">\n  <h3>23\ud3b8 \u2014 \uc131\ub2a5 \ud29c\ub2dd (shared_buffers\u00b7work_mem\u00b7VACUUM)<\/h3>\n  <p>\uc124\uc815 \ud30c\ub77c\ubbf8\ud130\u00b7autovacuum\u00b7bloat \uc7a1\uae30.<\/p>\n<\/div>\n\n<div class=\"series-nav\">\n  <strong>\ud83d\udcda PostgreSQL \ubc30\uc6b0\uae30 \uad50\uc7ac<\/strong><br>\n  \uc774\uc804: 21\ud3b8 \ubcf5\uc81c \u00b7 \ud604\uc7ac: <strong>22\ud3b8 (\uace0\uae09)<\/strong> \u00b7 \ub2e4\uc74c \u2192 23\ud3b8 \uc131\ub2a5 \ud29c\ub2dd \u00b7 \uc9c4\ud589: <strong>22\/24<\/strong>\n<\/div>\n\n<\/article>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>RANGE\u00b7LIST\u00b7HASH \ud30c\ud2f0\uc154\ub2dd\uacfc pg_partman. 24\ud3b8 \uad50\uc7ac 22\ud3b8.<\/p>\n","protected":false},"author":1,"featured_media":332,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-521","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\/521","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=521"}],"version-history":[{"count":0,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/posts\/521\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/media\/332"}],"wp:attachment":[{"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/media?parent=521"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/categories?post=521"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/tags?post=521"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}