{"id":734,"date":"2026-05-18T22:37:31","date_gmt":"2026-05-18T14:37:31","guid":{"rendered":"https:\/\/junai.ai\/blog\/n8n-postgres-18\/"},"modified":"2026-05-18T22:37:31","modified_gmt":"2026-05-18T14:37:31","slug":"n8n-postgres-18","status":"publish","type":"post","link":"https:\/\/junai.ai\/blog\/n8n-postgres-18\/","title":{"rendered":"n8n Postgres\u00b7Supabase\u00b7MySQL (Ch.18)"},"content":{"rendered":"\n<!-- WordPress REST API \ubc1c\ud589\uc6a9 HTML (\uc790\ub3d9 \uc0dd\uc131) -->\n<!-- WP-FEATURED-MEDIA-ID: 726 -->\n<div style=\"max-width:800px;margin:0 auto;\">\n<style>\n:root {--color-primary:#4f46e5;--color-accent:#6366f1;--color-bg:#fafbfc;--color-bg-card:#fff;--color-text:#1a202c;--color-text-muted:#64748b;--hero-start:#1e1b4b;--hero-end:#4338ca;}\n*{box-sizing:border-box;}\n.container{max-width:760px;margin:0 auto;padding:0 24px 80px;}\n.hero{background:linear-gradient(135deg,var(--hero-start) 0%,var(--hero-end) 100%);color:#fff;padding:80px 24px 60px;text-align:center;}\n.hero .eyebrow{display:inline-block;font-size:14px;color:#a5b4fc;font-weight:700;letter-spacing:0.1em;text-transform:uppercase;margin-bottom:14px;}\n.hero h1{font-size:36px;margin:0 0 16px;line-height:1.3;font-weight:800;}\n.hero p{color:#cbd5e1;font-size:18px;max-width:640px;margin:0 auto;line-height:1.6;}\n.hero img{width:100%;max-width:640px;height:auto;margin:32px auto 0;border-radius:10px;display:block;}\narticle{padding-top:48px;}\narticle h2{font-size:26px;margin:56px 0 20px;padding-left:14px;border-left:5px solid var(--color-accent);line-height:1.4;}\narticle h3{font-size:19px;margin:32px 0 12px;color:var(--color-primary);}\narticle p{margin:16px 0;}\narticle strong{color:var(--color-primary);font-weight:700;}\narticle code{background:#f1f5f9;padding:2px 8px;border-radius:4px;font-family:'SF Mono',Menlo,Consolas,monospace;font-size:14px;color:#4338ca;}\n.databox{background:#eef2ff;border-left:4px solid var(--color-accent);padding:16px 20px;margin:24px 0;border-radius:0 8px 8px 0;font-size:15.5px;}\n.databox strong{color:var(--color-primary);}\n.warnbox{background:linear-gradient(135deg,#fef3c7 0%,#fde68a 100%);padding:16px 20px;margin:24px 0;border-radius:8px;font-size:15.5px;}\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@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:#f1f5f9;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.cta{background:linear-gradient(135deg,#4338ca 0%,#6366f1 100%);color:#fff;padding:28px 24px;border-radius:12px;margin:48px 0 0;text-align:center;}\n.cta h3{color:#fff;margin:0 0 8px;font-size:20px;}\n.cta p{color:#c7d2fe;margin:0;font-size:15.5px;}\n.footer-nav{margin-top:32px;padding-top:20px;border-top:1px solid #e2e8f0;font-size:14px;color:var(--color-text-muted);}\n.footer-nav a{color:var(--color-primary);text-decoration:none;}\n@media (max-width:480px){.hero h1{font-size:26px;}.hero p{font-size:16px;}article h2{font-size:21px;}article h3{font-size:17px;}body{font-size:16px;}}\n<\/style>\n<section class=\"hero\">\n  <span class=\"eyebrow\">n8n \uad50\uc7ac \u00b7 \uace0\uae09 18\ud3b8<\/span>\n  <h1>n8n Postgres \u00b7 Supabase \u00b7 MySQL \uc5f0\ub3d9<\/h1>\n  <p>Upsert\u00b7\ud2b8\ub79c\uc7ad\uc158\u00b7\uc5f0\uacb0 \ud480\uae4c\uc9c0 \u2014 \uc6cc\ud06c\ud50c\ub85c\uac00 DB \ub97c \uc548\uc804\ud558\uac8c \ub450\ub4dc\ub9ac\ub294 4\uac00\uc9c0 \ud328\ud134.<\/p>\n  <img decoding=\"async\" src=\"https:\/\/junai.ai\/blog\/wp-content\/uploads\/2026\/05\/hero-5-17.jpg\" alt=\"\uc6cc\ud06c\ud50c\ub85c \ub178\ub4dc\ub4e4\uc774 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2e4\ub9b0\ub354 \uc544\uc774\ucf58\uc73c\ub85c \uc5f0\uacb0\uc120\uc744 \ubed7\ub294 \uc77c\ub7ec\uc2a4\ud2b8 \u2014 n8n DB \uc5f0\ub3d9 \ucee8\uc149\">\n<\/section>\n\n<div class=\"container\">\n<article>\n\n<p>n8n \uc73c\ub85c \ub9e4\uc77c 100\uac74\uc529 \ub370\uc774\ud130\ub97c \uc313\ub2e4 \ubcf4\uba74 \uc5b4\ub290 \uc2dc\uc810\uc5d0 <strong>Sheets \uc758 \ud55c\uacc4<\/strong>\uac00 \uc628\ub2e4 \u2014 1000\ud589 \ub118\uc5b4\uac00\uba74 \ub290\ub824\uc9c0\uace0, \ub3d9\uc2dc \uc4f0\uae30\uc5d0\uc11c \ucda9\ub3cc\uc774 \ub098\uace0, \ucffc\ub9ac\uac00 \uc548 \ub41c\ub2e4. \ub2f5\uc740 \uba85\ud655. Postgres (\ub610\ub294 Supabase\u00b7MySQL) \ub85c \uc62e\uae30\ub294 \uac83.<\/p>\n\n<p>\uc774\ubc88 18\ud3b8\uc740 DB \uc785\ubb38\uc774 \uc544\ub2c8\ub77c <strong>n8n \uc548\uc5d0\uc11c DB \ub178\ub4dc\ub97c \uc548\uc804\ud558\uac8c \uc4f0\ub294 \ud328\ud134<\/strong>. Upsert \uac00 \uc65c update \ub97c \uc548 \ud560 \ub54c\uac00 \uc788\ub294\uc9c0, \uc5f0\uacb0 \ud480\uc740 \uc5b4\ub5bb\uac8c \uc7a1\ub294\uc9c0, 1\ub9cc \uac74 batch \ucc98\ub9ac \uc2dc deadlock \uc744 \uc5b4\ub5bb\uac8c \ud53c\ud558\ub294\uc9c0 \u2014 \uc6b4\uc601\uc5d0\uc11c \uc9c4\uc9dc \ub9c8\uc8fc\uce58\ub294 \ubb38\uc81c\ub4e4\uc744 \uc9da\ub294\ub2e4.<\/p>\n\n<h2>1. \uc5b4\ub5a4 DB \ub97c \uace0\ub97c\uae4c \u2014 3\uac00\uc9c0 \ube44\uad50<\/h2>\n\n<p>n8n \uc740 \uc138 DB \uc804\ubd80 native \ub178\ub4dc\ub97c \uc81c\uacf5\ud55c\ub2e4. \uae30\ub2a5\uc740 \ube44\uc2b7\ud558\uc9c0\ub9cc <strong>\uc6b4\uc601 \ube44\uc6a9\u00b7\ubcf5\uc7a1\ub3c4\u00b7\ud655\uc7a5\uc131<\/strong>\uc774 \ub2e4\ub974\ub2e4. \ud55c \uc904 \uc815\ub9ac.<\/p>\n\n<div class=\"tablewrap\">\n<table>\n<thead><tr><th>\uc635\uc158<\/th><th>\uac15\uc810<\/th><th>\uc57d\uc810<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>Supabase (Postgres \ud638\uc2a4\ud305)<\/td><td data-label=\"\uac15\uc810\">SQL+REST+Realtime+Auth \ubb36\uc74c. \ubb34\ub8cc \ud2f0\uc5b4 500MB. n8n \uc5d0\uc120 Postgres \ub178\ub4dc\ub85c \uadf8\ub300\ub85c \uc811\uc18d<\/td><td data-label=\"\uc57d\uc810\">5\ubd84 idle \ud6c4 sleep (\ubb34\ub8cc) \u2192 \uccab \ucffc\ub9ac cold start 2-3\ucd08<\/td><\/tr>\n<tr><td>Self-host Postgres<\/td><td data-label=\"\uac15\uc810\">\uc644\uc804 \uc81c\uc5b4\u00b7\ubb34\uc81c\ud55c \uc6a9\ub7c9\u00b7\ud2b8\ub79c\uc7ad\uc158 \ubcf4\uc7a5<\/td><td data-label=\"\uc57d\uc810\">\ubc31\uc5c5\u00b7\ubaa8\ub2c8\ud130\ub9c1 \uc9c1\uc811 \uad00\ub9ac. \ubc15\uc900\uc131\ub2d8 docker compose \uc548\uc5d0\uc11c docker-postgres \ucd94\uac00 \uad8c\uc7a5<\/td><\/tr>\n<tr><td>MySQL\/MariaDB<\/td><td data-label=\"\uac15\uc810\">WordPress \uac00 \uc774\ubbf8 \uc4f0\uace0 \uc788\uc73c\uba74 \uac19\uc740 \uc778\uc2a4\ud134\uc2a4 \uc7ac\ud65c\uc6a9 \uac00\ub2a5. n8n MySQL \ub178\ub4dc \uc548\uc815<\/td><td data-label=\"\uc57d\uc810\">UPSERT \ubb38\ubc95\uc774 Postgres \ubcf4\ub2e4 \ub5a8\uc5b4\uc9d0 (<code>ON DUPLICATE KEY UPDATE<\/code> \ub9cc, RETURNING \ubbf8\uc9c0\uc6d0)<\/td><\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n\n<div class=\"databox\">\n<strong>\uc65c Postgres \uc6b0\uc704<\/strong> \u2014 n8n \uc758 Workflow Static Data \ub3c4 Postgres \ubc31\uc5d4\ub4dc\ub97c \uc815\uc2dd \uc9c0\uc6d0. JSON \uceec\ub7fc \ud0c0\uc785\uc774 \uc6b0\uc6d4\ud558\uace0 <code>RETURNING<\/code> \uc808\ub85c Upsert \uac80\uc99d\uc744 \ub2e8\uacc4 1\ubc88\uc5d0 \ub05d\ub0bc \uc218 \uc788\ub2e4. WordPress MySQL \uacfc \ubd84\ub9ac\ud574\uc11c \ubcc4\ub3c4 Postgres \ub450\ub294 \uac8c \ub514\ud3f4\ud2b8.\n<\/div>\n\n<h2>2. Upsert \u2014 &#8220;insert or update&#8221; \uac00 update \uc548 \ud560 \ub54c \ud568\uc815<\/h2>\n\n<p>n8n Postgres \ub178\ub4dc\uc758 <strong>Operation: Insert or Update<\/strong> \uac00 \uac00\uc7a5 \uc790\uc8fc \uc5b4\uae0b\ub09c\ub2e4. \uc99d\uc0c1\uc740 \ub2e8\uc21c \u2014 &#8220;row \uac00 \uc0dd\uc131\uc740 \ub418\ub294\ub370 \uac19\uc740 \ud0a4 \ub2e4\uc2dc \ubcf4\ub0b4\uba74 update \uac00 \uc548 \ub428&#8221;. \uc6d0\uc778\uc740 \uac70\uc758 \ud56d\uc0c1 \uac19\ub2e4.<\/p>\n\n<h3>\uc6d0\uc778 1 \u2014 UNIQUE constraint \ubd80\uc7ac<\/h3>\n\n<p>Postgres \uc758 <code>ON CONFLICT<\/code> \ub294 <strong>UNIQUE \uc778\ub371\uc2a4<\/strong>\uac00 \ucda9\ub3cc \ub300\uc0c1 \uceec\ub7fc\uc5d0 \uac78\ub824\uc788\uc5b4\uc57c \uc791\ub3d9\ud55c\ub2e4. n8n \ub178\ub4dc\uc758 &#8220;Update Key&#8221; \ud544\ub4dc\uc5d0 \uceec\ub7fc\uba85\ub9cc \uc801\uc5c8\ub2e4\uace0 \uc790\ub3d9\uc73c\ub85c UNIQUE \uac00 \ub9cc\ub4e4\uc5b4\uc9c0\uc9c4 \uc54a\uc74c.<\/p>\n\n<p>\uba3c\uc800 \ud55c \ubc88:<\/p>\n\n<p><code>CREATE UNIQUE INDEX user_email_idx ON users (email);<\/code><\/p>\n\n<p>\uc774\uac78 \ud574\ub450\uace0 n8n \ub178\ub4dc\uc758 Update Key \ub97c <code>email<\/code> \ub85c \uc124\uc815\ud574\uc57c \uc815\uc0c1 Upsert.<\/p>\n\n<h3>\uc6d0\uc778 2 \u2014 Operation \uacb0\uacfc\ub97c \uac80\uc99d \uc548 \ud568<\/h3>\n\n<p>n8n \uc740 <strong>&#8220;\ucffc\ub9ac \uc2e4\ud589 \uc131\uacf5&#8221;<\/strong> \uacfc <strong>&#8220;row \uac00 \uc2e4\uc81c \ubc14\ub01c&#8221;<\/strong> \uc744 \uad6c\ubd84 \uc548 \ud55c\ub2e4. ON CONFLICT \uac00 \ub9e4\uce58 \uc548 \ub3fc\uc11c 0\ud589 \uc601\ud5a5\uc774\uc5b4\ub3c4 \ub178\ub4dc\ub294 success. \uc6b4\uc601\uc5d0\uc120 <strong>RETURNING \uc808\uc744 \ucd94\uac00 + \ub2e4\uc74c IF \ub178\ub4dc\ub85c \uac80\uc99d<\/strong>\uc774 \uc815\uacf5\ubc95.<\/p>\n\n<p>Execute Query \ubaa8\ub4dc\ub85c \uc804\ud658 \ud6c4:<\/p>\n\n<p><code>INSERT INTO users (email, name) VALUES ($1, $2)<br>ON CONFLICT (email) DO UPDATE SET name = EXCLUDED.name<br>RETURNING (xmax = 0) AS inserted, *;<\/code><\/p>\n\n<p><code>inserted=true<\/code> \uba74 \uc2e0\uaddc insert, <code>false<\/code> \uba74 update. \uc774\uac78 IF \ub178\ub4dc\ub85c \ubd84\uae30\ud558\uba74 &#8220;\uc2e0\uaddc \uac00\uc785 \ud658\uc601 \uba54\uc77c&#8221; \uacfc &#8220;\uc815\ubcf4 \uac31\uc2e0 \uc54c\ub9bc&#8221; \uc744 \uc790\ub3d9 \ub77c\uc6b0\ud305 \uac00\ub2a5.<\/p>\n\n<h2>3. \ud2b8\ub79c\uc7ad\uc158 \u2014 n8n \ub178\ub4dc\uc758 \ud55c\uacc4\uc640 \uc6b0\ud68c<\/h2>\n\n<p>n8n Postgres \ub178\ub4dc\ub294 <strong>Settings \u2192 Execute Queries in Transaction<\/strong> \uc635\uc158\uc744 \ucf1c\uba74 \ub178\ub4dc \ud55c \uac1c \uc548\uc5d0\uc11c \uc5ec\ub7ec row \uac00 \ud2b8\ub79c\uc7ad\uc158\uc73c\ub85c \ubb36\uc778\ub2e4. \ud55c row \ub77c\ub3c4 \uc2e4\ud328\ud558\uba74 \uc804\uccb4 rollback.<\/p>\n\n<p>\ud55c\uacc4\ub294 <strong>\ub178\ub4dc \uacbd\uacc4\ub97c \ub118\ub294 \ud2b8\ub79c\uc7ad\uc158\uc774 \ubd88\uac00\ub2a5<\/strong>\ud558\ub2e4\ub294 \uac83. \uc6cc\ud06c\ud50c\ub85c\uac00 &#8220;Postgres insert \u2192 API \ud638\ucd9c \u2192 Postgres update&#8221; \uc778\ub370 API \uac00 \uc2e4\ud328\ud574\ub3c4 \uccab insert \ub294 commit \ub41c \uc0c1\ud0dc. \uc9c4\uc9dc atomicity \uac00 \ud544\uc694\ud558\uba74 \ub450 \uac00\uc9c0 \uc6b0\ud68c.<\/p>\n\n<h3>\ubc29\ubc95 A \u2014 \ubaa8\ub4e0 DB \uc791\uc5c5\uc744 \ud55c Postgres \ub178\ub4dc (Execute Query) \uc548\uc5d0\uc11c<\/h3>\n\n<p>BEGIN\/COMMIT \uba85\uc2dc:<\/p>\n\n<p><code>BEGIN;<br>INSERT INTO orders ...;<br>UPDATE inventory SET qty = qty - 1 WHERE id = $1;<br>COMMIT;<\/code><\/p>\n\n<p>\uc911\uac04\uc5d0 API \ud638\ucd9c\uc774 \ub07c\uba74 \uc774 \ud328\ud134\uc740 \ubabb \uc500. \uadf8\ub550 \ubc29\ubc95 B.<\/p>\n\n<h3>\ubc29\ubc95 B \u2014 Saga \ud328\ud134 (\ubcf4\uc0c1 \ud2b8\ub79c\uc7ad\uc158)<\/h3>\n\n<p>\uac01 \ub2e8\uacc4\ub9c8\ub2e4 &#8220;\uc2e4\ud328 \uc2dc \ub418\ub3cc\ub9b4 action&#8221; \uc744 \ubbf8\ub9ac \uc815\uc758. \uc608: API \uc2e4\ud328 \u2192 Error Trigger \u2192 \uc774\uc804\uc5d0 insert \ud55c orders.id \ub97c \ubc1b\uc544\uc11c DELETE. 17\ud3b8 (Error Workflow) \uc758 Rollback \ub2e8\uacc4\uac00 \uc774\uac78 \uad6c\ud604\ud558\ub294 \uc790\ub9ac.<\/p>\n\n<h2>4. \uc5f0\uacb0 \ud480 + Deadlock \u2014 1\ub9cc \uac74 batch \uc758 \ud568\uc815<\/h2>\n\n<p>&#8220;\ub9e4\uc77c \uc0c8\ubcbd 1\ub9cc \uac74 \ub3d9\uae30\ud654&#8221; \uac19\uc740 \uc6cc\ud06c\ud50c\ub85c\ub97c 14\ud3b8 Split In Batches \ub85c \uc9dc\ub193\uc73c\uba74 100\uac1c\uc529 \ub04a\uaca8\uc11c \ub3c4\ub294\ub370, \ub3d9\uc2dc\uc131\uc774 \ub192\uc544\uc9c0\uba74 \ub450 \uac00\uc9c0 \uc0ac\uace0\uac00 \ub09c\ub2e4.<\/p>\n\n<div class=\"warnbox\">\n<strong>\uc2e4\uc81c \uc0ac\ub840<\/strong> \u2014 n8n \ucee4\ubba4\ub2c8\ud2f0 \uc0ac\ub840: \ubd84\ub2f9 10k+ row UPSERT \uc6cc\ud06c\ud50c\ub85c\uac00 deadlock \uc73c\ub85c \uba48\ucda4. \uc6d0\uc778\uc740 \ub3d9\uc77c row \ub97c \uc5ec\ub7ec batch \uac00 \ub3d9\uc2dc \uc7a0\uae08. \uac19\uc740 \ud0a4\ub85c ORDER BY \ud6c4 batch \ubd84\ud560\ub85c \ud574\uacb0.\n<\/div>\n\n<h3>\uc5f0\uacb0 \ud480 \uc0ac\uc774\uc9d5<\/h3>\n\n<p>n8n Postgres \ub178\ub4dc\ub294 \ud638\ucd9c\ub9c8\ub2e4 \uc0c8 \uc5f0\uacb0\uc744 \uc7a1\ub294\ub2e4. Supabase \ubb34\ub8cc \ud2f0\uc5b4\ub294 \ub3d9\uc2dc 60 \uc5f0\uacb0 \ud55c\ub3c4\ub77c batch 100\uac1c\uac00 \ubcd1\ub82c\ub85c \uac00\uba74 \ub2e4 \ub9c9\ud798. \ub450 \uac00\uc9c0 \ucc98\ub9ac:<\/p>\n\n<ul>\n<li><strong>n8n \uce21<\/strong> \u2014 Split In Batches \uc758 Batch Size \ub97c \uc904\uc784 (100 \u2192 25) + Wait \ub178\ub4dc 1-2\ucd08 \ub07c\uc6c0<\/li>\n<li><strong>Supabase \uce21<\/strong> \u2014 Supabase \uc758 PgBouncer (Transaction mode) \uc0ac\uc6a9. \ub178\ub4dc \uc5f0\uacb0 \ubb38\uc790\uc5f4\uc744 6543 \ud3ec\ud2b8\ub85c (5432 \uc9c1\uc811 \uc5f0\uacb0 \ub300\uc2e0)<\/li>\n<\/ul>\n\n<h3>Deadlock \ud68c\ud53c<\/h3>\n\n<p>\uac19\uc740 row \ub97c \ub450 batch \uac00 \ub3d9\uc2dc \uc7a0\uadf8\uba74 Postgres \uac00 \ud55c\ucabd\uc744 \uc8fd\uc778\ub2e4. \ud328\ud134:<\/p>\n\n<ol>\n<li>batch \ubd84\ud560 \uc804\uc5d0 \ub370\uc774\ud130\ub97c <strong>UPSERT \ud0a4 (PK \ub610\ub294 UNIQUE) \ub85c ORDER BY<\/strong><\/li>\n<li>\uac19\uc740 \ud0a4 \ubc94\uc704\ub294 \uac19\uc740 batch \uc548\uc5d0 \uac00\ub3c4\ub85d<\/li>\n<li>\uadf8\ub798\ub3c4 deadlock \ubc1c\uc0dd \uc2dc 17\ud3b8 Retry on Fail + \uc9c0\uc218 \ubc31\uc624\ud504 (5s\u00b710s\u00b720s)<\/li>\n<\/ol>\n\n<p>\uc774 \ud328\ud134\uc774 \uc790\ub9ac \uc7a1\uc73c\uba74 \uc0c8\ubcbd \ub3d9\uae30\ud654\uac00 \uc548\uc815\uc801\uc73c\ub85c \ub3cc\uc544\uac04\ub2e4. \ub2e4\uc74c 15\ud3b8 Merge \ub178\ub4dc + 16\ud3b8 Sub-Workflow \ub85c \uac00\uba74 DB \uc791\uc5c5\uc744 \uc7ac\uc0ac\uc6a9 \uac00\ub2a5\ud55c \ubaa8\ub4c8\ub85c \ubd84\ub9ac\ud558\ub294 \ubc95\uae4c\uc9c0 \uc644\uc131.<\/p>\n\n<div class=\"cta\">\n<h3>\ub2e4\uc74c \uae00<\/h3>\n<p>n8n \uad50\uc7ac 15\ud3b8 \u2014 Merge \ub178\ub4dc + \uc870\uc778 \ud328\ud134. Append \u00b7 Keep Key \u00b7 SQL Join \uc73c\ub85c \ub450 \ub370\uc774\ud130 \uc2a4\ud2b8\ub9bc \ud569\uce58\uae30.<\/p>\n<\/div>\n\n<div class=\"footer-nav\">\nn8n \uad50\uc7ac \uc2dc\ub9ac\uc988 \u00b7\n<a href=\"https:\/\/junai.ai\/blog\/n8n-loop-batch-14\/\">14\ud3b8 Loop\u00b7Batch<\/a> \u00b7\n<a href=\"https:\/\/junai.ai\/blog\/n8n-error-workflow-17\/\">17\ud3b8 Error<\/a> \u00b7\n<strong>18\ud3b8 Postgres<\/strong> \u00b7\n<a href=\"https:\/\/junai.ai\/blog\/n8n-ai-agent-19\/\">19\ud3b8 AI Agent<\/a>\n<\/div>\n\n<\/article>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>n8n Postgres \u2014 Upsert\u00b7\ud2b8\ub79c\uc7ad\uc158\u00b7\uc5f0\uacb0 \ud480. deadlock \ud68c\ud53c + RETURNING \uac80\uc99d.<\/p>\n","protected":false},"author":1,"featured_media":726,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[],"class_list":["post-734","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-n8n"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/posts\/734","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=734"}],"version-history":[{"count":0,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/posts\/734\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/media\/726"}],"wp:attachment":[{"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/media?parent=734"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/categories?post=734"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/tags?post=734"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}