{"id":39554,"date":"2026-06-16T08:51:29","date_gmt":"2026-06-15T23:51:29","guid":{"rendered":"https:\/\/jore2.com\/community-12826-how-timescaledb-compresses-time-series-data\/"},"modified":"2026-06-16T08:51:29","modified_gmt":"2026-06-15T23:51:29","slug":"community-12826-how-timescaledb-compresses-time-series-data","status":"publish","type":"post","link":"https:\/\/jore2.com\/?p=39554","title":{"rendered":"\ub370\uc774\ud130 \ud3ed\uc99d \uc2dc\ub300, 98% \uc555\ucd95\uc73c\ub85c \uc800\uc7a5\uc18c \ube44\uc6a9\uc744 \ub0a0\ub9ac\ub294 \uae30\uc220\uc758 \ube44\ubc00"},"content":{"rendered":"<div class=\"jore2-editor-byline\">\n<p><strong>\ubc30\uc18c\ub77c<\/strong><\/p>\n<\/div>\n<p>\ub370\uc774\ud130\uac00 \ud3ed\ubc1c\uc801\uc73c\ub85c \ub298\uc5b4\ub098\ub294 \uc694\uc998, \uc800\uc7a5\uc18c \ube44\uc6a9\uc740 \ub2e8\uc21c\ud55c \uc9c0\ucd9c\uc744 \ub118\uc5b4 \uc6b4\uc601\uc758 \uc131\ud328\ub97c \uac00\ub974\ub294 \ud575\uc2ec \ubcc0\uc218\uac00 \ub418\uc5c8\uc2b5\ub2c8\ub2e4. \ud2b9\ud788 IoT \uc13c\uc11c\ub098 \uae08\uc735 \uc2dc\uacc4\uc5f4 \ub370\uc774\ud130\ub97c \ub2e4\ub8e8\ub294 \ud658\uacbd\uc5d0\uc11c\ub294 \ub370\uc774\ud130 \uc591\uc774 \uae30\ud558\uae09\uc218\uc801\uc73c\ub85c \uc99d\uac00\ud574 \uae30\uc874 \ubc29\uc2dd\uc73c\ub85c\ub294 \uac10\ub2f9\ud558\uae30 \uc5b4\ub824\uc6b4 \ubd80\ub2f4\uc774 \uc0dd\uae41\ub2c8\ub2e4.<\/p>\n<p>\uc774\ub7f0 \uc0c1\ud669\uc5d0\uc11c \ud0c0\uc784\uc2a4\ucf00\uc77cDB\uac00 \uae30\uc874 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640\ub294 \ucc28\uc6d0\uc774 \ub2e4\ub978 \uc555\ucd95 \uae30\uc220\uc744 \uc120\ubcf4\uc774\uba70 \uae30\uc220\uacc4\uc758 \uc774\ubaa9\uc744 \uc9d1\uc911\uc2dc\ud0a4\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uae30\uc874\uc758 \ud3ec\uc2a4\ud2b8\uadf8\ub808SQL\uc774 \uc0ac\uc6a9\ud558\ub294 TOAST \ubc29\uc2dd\uc740 \uac1c\ubcc4\uc801\uc73c\ub85c \ud070 \uac12\uc744 \ucc98\ub9ac\ud558\ub294 \ub370 \ud2b9\ud654\ub418\uc5b4 \uc788\uc9c0\ub9cc, \uc2dc\uacc4\uc5f4 \ub370\uc774\ud130 \ud2b9\uc720\uc758 \ud328\ud134\uc744 \ud65c\uc6a9\ud558\uc9c0\ub294 \ubabb\ud588\uc2b5\ub2c8\ub2e4. \ud0c0\uc784\uc2a4\ucf00\uc77cDB\ub294 \ud558\uc774\ud37c\ucf54\uc5b4 \uc5d4\uc9c4\uc744 \ud1b5\ud574 \ud589 \ub2e8\uc704 \uc800\uc7a5\uc744 \uc5f4 \ub2e8\uc704 \uc800\uc7a5\uc73c\ub85c \uc804\ud658\ud558\uba70 \uadfc\ubcf8\uc801\uc778 \uc811\uadfc\ubc95\uc744 \ubc14\uafe8\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc774 \ubc29\uc2dd\uc740 \ub370\uc774\ud130\uc758 \ud2b9\uc131\uc5d0 \ub530\ub77c \ub378\ud0c0 \uc778\ucf54\ub529\uc774\ub098 \uace0\ub9b4\ub77c XOR \uac19\uc740 \uc804\uc6a9 \uc54c\uace0\ub9ac\uc998\uc744 \uc801\uc6a9\ud574 \ubd88\ud544\uc694\ud55c \ube44\ud2b8\ub97c \uacfc\uac10\ud788 \uc81c\uac70\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc2e4\uc81c \uc13c\uc11c\uac00 10 \ucd08\ub9c8\ub2e4 \uc77c\uc815\ud55c \uac04\uaca9\uc73c\ub85c \ub370\uc774\ud130\ub97c \uc804\uc1a1\ud560 \ub54c, \uc2dc\uac04 \uac04\uaca9\uc758 \ubcc0\ud654\ub7c9\ub9cc \uc800\uc7a5\ud558\uba74 \ub300\ubd80\ubd84\uc758 \ub370\uc774\ud130\uac00 \uac70\uc758 \uc81c\ub85c\uc5d0 \uac00\uae5d\uac8c \uc555\ucd95\ub429\ub2c8\ub2e4. \uc628\ub3c4\uac00 20.1 \ub3c4\uc5d0\uc11c 20.3 \ub3c4\ucc98\ub7fc \uc11c\uc11c\ud788 \ubcc0\ud558\ub294 \ubd80\ub3d9\uc18c\uc218\uc810 \uac12\ub3c4 \uc804\uccb4 8 \ubc14\uc774\ud2b8 \ub300\uc2e0 \uba87 \ube44\ud2b8\ub9cc\uc73c\ub85c \ud45c\ud604\uc774 \uac00\ub2a5\ud574\uc9d1\ub2c8\ub2e4.<\/p>\n<p>\uc800\uce74\ub514\ub110\ub9ac\ud2f0\ub97c \uac00\uc9c4 \uc0c1\ud0dc \ucf54\ub4dc\ub098 \uc7a5\uce58 \uc720\ud615 \uac19\uc740 \ubc18\ubcf5\ub418\ub294 \uac12\uc740 \uc0ac\uc804 \uc778\ucf54\ub529\uc744 \ud1b5\ud574 \ucc38\uc870 \ubc88\ud638\ub85c \uce58\ud658\ub418\uba70, \ucd5c\uc885\uc801\uc73c\ub85c LZ \uc555\ucd95\uc774 \ub354\ud574\uc838 \uc555\ucd95 \ud6a8\uc728\uc744 \uadf9\ub300\ud654\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc774\ub7ec\ud55c \uae30\uc220\uc801 \ubcc0\ud654\ub294 \ub2e8\uc21c\ud55c \uc800\uc7a5 \uacf5\uac04 \ud655\ubcf4\ub97c \ub118\uc5b4 \ucffc\ub9ac \uc131\ub2a5\uc5d0\ub3c4 \uae0d\uc815\uc801\uc778 \uc601\ud5a5\uc744 \ubbf8\uce69\ub2c8\ub2e4. \uc555\ucd95\ub41c \ub370\uc774\ud130\ub97c \uc77d\uc744 \ub54c \ub514\ucf54\ub529 \uc624\ucc28\uac00 \ubc1c\uc0dd\ud558\ub354\ub77c\ub3c4, \ud544\ud130\ub9c1 \ub2e8\uacc4\uc5d0\uc11c \ubd88\ud544\uc694\ud55c \uc2a4\uce94\uc744 \uc904\uc5ec \uc804\uccb4 \ucc98\ub9ac \uc18d\ub3c4\ub97c \ub192\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ud2b9\ud788 \uc0ac\uc804 \uc778\ucf54\ub529\uc744 \ud1b5\ud574 \ubb38\uc790\uc5f4 \ube44\uad50\ub97c \uc815\uc218 \ube44\uad50\ub85c \ubcc0\ud658\ud558\uba74 \ubcf5\uc7a1\ud55c \uc870\uac74\ubb38\uc5d0\uc11c\ub3c4 \ube60\ub978 \uc751\ub2f5\uc744 \uae30\ub300\ud560 \uc218 \uc788\uc5b4 \ubd84\uc11d \uc791\uc5c5\uc758 \ud6a8\uc728\uc131\uc774 \ud06c\uac8c \uac1c\uc120\ub429\ub2c8\ub2e4.<\/p>\n<p>\uc774\uc81c \ub370\uc774\ud130 \uc544\uce74\uc774\ube59\uc774\ub098 \ud30c\ud2f0\uc154\ub2dd\uc73c\ub85c \uc2dc\uac04\uc744 \ubc8c\ub358 \uc2dc\uae30\ub294 \uc800\ubb3c\uace0, \ubaa8\ub4e0 \ub370\uc774\ud130\ub97c \uc628\ub77c\uc778 \uc0c1\ud0dc\uc5d0\uc11c \uc555\ucd95\ub41c \ucc44\ub85c \uc2e4\uc2dc\uac04\uc73c\ub85c \uc870\ud68c\ud558\ub294 \uc2dc\ub300\uac00 \uc5f4\ub838\uc2b5\ub2c8\ub2e4. \uc800\uc7a5 \ube44\uc6a9 \ubd80\ub2f4\uc744 \uc904\uc774\uba74\uc11c\ub3c4 \ub370\uc774\ud130\uc758 \uac00\uce58\ub97c \uc989\uac01\uc801\uc73c\ub85c \ud65c\uc6a9\ud558\ub824\ub294 \uae30\uc5c5\ub4e4\uc758 \uc6c0\uc9c1\uc784\uc774 \ud65c\ubc1c\ud574\uc9c0\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ud5a5\ud6c4 \uc2dc\uacc4\uc5f4 \ub370\uc774\ud130\ub97c \ub2e4\ub8e8\ub294 \ubaa8\ub4e0 \uc2dc\uc2a4\ud15c\uc774 \uc774 \uac19\uc740 \uc5f4 \uae30\ubc18 \uc555\ucd95 \uc804\ub7b5\uc744 \ud45c\uc900\uc73c\ub85c \ubc1b\uc544\ub4e4\uc774\uac8c \ub420\uc9c0, \uadf8\ub9ac\uace0 \uadf8 \ud55c\uacc4\uac00 \uc5b4\ub514\uae4c\uc9c0 \ud655\uc7a5\ub420\uc9c0 \uc9c0\ucf1c\ubcfc \ud544\uc694\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>IoT \uc13c\uc11c\uc640 \uc2e4\uc2dc\uac04 \ubaa8\ub2c8\ud130\ub9c1\uc774 \uc77c\uc0c1\ud654\ub418\uba74\uc11c \ub370\uc774\ud130 \uc800\uc7a5 \ube44\uc6a9\uc740 \uae30\uc5c5\uc758 \uac00\uc7a5 \ud070 \uace0\ubbfc\uc774 \ub418\uc5c8\uc2b5\ub2c8\ub2e4. \ud3ec\uc2a4\ud2b8\uadf8\ub808SQL \uae30\ubc18\uc758 \ud0c0\uc784\uc2a4\ucf00\uc77cDB\uac00 \uae30\uc874 \ubc29\uc2dd\uacfc \uadfc\ubcf8\uc801\uc73c\ub85c \ub2e4\ub978 \uc555\ucd95 \uc804\ub7b5\uc73c\ub85c 98%\uc5d0 \ub2ec\ud558\ub294 \uc800\uc7a5 \uacf5\uac04 \uc808\uc57d\uc744 \uc2e4\ud604\ud558\uba70 \uc8fc\ubaa9\ubc1b\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"author":11,"featured_media":39553,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[406],"tags":[3565,13827,12390,25173,26558,26559],"class_list":["post-39554","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-406","tag-db","tag-iot","tag-sql","tag-25173","tag-26558","tag-26559"],"featured_image_urls":{"full":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/06\/community-12826-how-timescaledb-compresses-time-series-data.png",1200,630,false],"thumbnail":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/06\/community-12826-how-timescaledb-compresses-time-series-data-150x150.png",150,150,true],"medium":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/06\/community-12826-how-timescaledb-compresses-time-series-data-300x158.png",300,158,true],"medium_large":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/06\/community-12826-how-timescaledb-compresses-time-series-data-768x403.png",640,336,true],"large":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/06\/community-12826-how-timescaledb-compresses-time-series-data-1024x538.png",640,336,true],"1536x1536":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/06\/community-12826-how-timescaledb-compresses-time-series-data.png",1200,630,false],"2048x2048":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/06\/community-12826-how-timescaledb-compresses-time-series-data.png",1200,630,false],"morenews-large":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/06\/community-12826-how-timescaledb-compresses-time-series-data-825x575.png",825,575,true],"morenews-medium":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/06\/community-12826-how-timescaledb-compresses-time-series-data-590x410.png",590,410,true]},"author_info":{"info":["\ubc30\uc18c\ub77c"]},"category_info":"<a href=\"https:\/\/jore2.com\/?cat=406\" rel=\"category\">\uc694\uc998\ub728\ub294\uc18c\uc2dd<\/a>","tag_info":"\uc694\uc998\ub728\ub294\uc18c\uc2dd","comment_count":"0","_links":{"self":[{"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/posts\/39554","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=39554"}],"version-history":[{"count":0,"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/posts\/39554\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/media\/39553"}],"wp:attachment":[{"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=39554"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=39554"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=39554"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}