{"id":2876,"date":"2013-06-27T17:21:50","date_gmt":"2013-06-27T08:21:50","guid":{"rendered":"http:\/\/www.techscore.com\/blog\/?p=2876"},"modified":"2018-11-14T16:33:54","modified_gmt":"2018-11-14T07:33:54","slug":"%e7%a4%be%e5%86%85-postgresql-%e5%8b%89%e5%bc%b7%e4%bc%9a%e3%83%ac%e3%83%9d%e3%83%bc%e3%83%88","status":"publish","type":"post","link":"https:\/\/www.techscore.com\/blog\/2013\/06\/27\/%e7%a4%be%e5%86%85-postgresql-%e5%8b%89%e5%bc%b7%e4%bc%9a%e3%83%ac%e3%83%9d%e3%83%bc%e3%83%88\/","title":{"rendered":"\u793e\u5185 PostgreSQL \u52c9\u5f37\u4f1a\u30ec\u30dd\u30fc\u30c8"},"content":{"rendered":"<p>\u3053\u3093\u306b\u3061\u306f\u3001\u9234\u6728\u3067\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\u5148\u65e5\u884c\u3063\u305f\u793e\u5185 PostgreSQL \u52c9\u5f37\u4f1a\u3092\u30ec\u30dd\u30fc\u30c8\u3057\u307e\u3059\uff01<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.techscore.com\/blog\/wp\/wp-content\/uploads\/2013\/06\/study-postgresql-011.jpg\" rel=\"facebox\" rel=\"attachment wp-att-2883\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-2883\" alt=\"study-postgresql-01\" src=\"https:\/\/www.techscore.com\/blog\/wp\/wp-content\/uploads\/2013\/06\/study-postgresql-011.jpg\" width=\"640\" height=\"478\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>\u4eca\u307e\u3067\u306e\u793e\u5185\u52c9\u5f37\u4f1a\u306f\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u5bc4\u308a\u306e\u5185\u5bb9\u304c\u591a\u304b\u3063\u305f\u306e\u3067\u3059\u304c\u3001<\/p>\n<p>\u4eca\u56de\u306f\u30a4\u30f3\u30d5\u30e9\u306e\u65b9\u306b\u3082\u767a\u8868\u306b\u53c2\u52a0\u3057\u3066\u3044\u305f\u3060\u304d\u307e\u3057\u305f\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\u30c6\u30fc\u30de\u306f PostgreSQL \u3067\u3059\uff01<\/p>\n<p>\u6700\u8fd1\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3067\u8ffd\u52a0\u3055\u308c\u305f\u6a5f\u80fd\u306e\u7d39\u4ecb\u3084\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u3064\u3044\u3066\u306e\u767a\u8868\u3092\u884c\u3044\u307e\u3057\u305f\u3002<\/p>\n<p>&nbsp;<\/p>\n<h2>\u30e9\u30a4\u30c8\u30cb\u30f3\u30b0\u30c8\u30fc\u30af<\/h2>\n<p>\u30e9\u30a4\u30c8\u30cb\u30f3\u30b0\u30c8\u30fc\u30af\u306fTECHSCORE BLOG\u306e\u57f7\u7b46\u8005\u306e\u4e00\u4eba\u5317\u5ddd\u3055\u3093\u3067\u3059\u3002<br \/>\n\u5185\u5bb9\u306fPostgreSQL \u306e\u5404\u30d0\u30fc\u30b8\u30e7\u30f3\u3067\u8ffd\u52a0\u3055\u308c\u305f\u6a5f\u80fd\u306b\u3064\u3044\u3066\u306e\u304a\u3055\u3089\u3044\u3067\u3059\u3002<\/p>\n<p>8.2 \u4ee5\u964d\u306b\u8ffd\u52a0\u3055\u308c\u305f\u4e3b\u306a\u6a5f\u80fd\u306f\u4ee5\u4e0b\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n<table>\n<tbody>\n<tr>\n<th>\u30d0\u30fc\u30b8\u30e7\u30f3<\/th>\n<th>\u30ea\u30ea\u30fc\u30b9\u65e5<\/th>\n<th>\u4e3b\u306a\u6a5f\u80fd<\/th>\n<\/tr>\n<tr>\n<td>8.2<\/td>\n<td>2006\/12\/05<\/td>\n<td>\u30a6\u30a9\u30fc\u30e0\u30b9\u30bf\u30f3\u30d0\u30a4&nbsp;<\/p>\n<p>GIN\u30a4\u30f3\u30c7\u30c3\u30af\u30b9<\/td>\n<\/tr>\n<tr>\n<td>8.3<\/td>\n<td>2008\/02\/04<\/td>\n<td>HOT\u306b\u3088\u308b\u30b9\u30da\u30fc\u30b9\u518d\u5229\u7528\u306e\u6700\u9069\u5316&nbsp;<\/p>\n<p>XML\u578b,ENUM\u578b,UUID\u578b\u306e\u8ffd\u52a0<\/p>\n<p>\u5168\u6587\u691c\u7d22\u30a8\u30f3\u30b8\u30f3\u306e\u672c\u4f53\u7d71\u5408<\/td>\n<\/tr>\n<tr>\n<td>8.4<\/td>\n<td>2009\/07\/01<\/td>\n<td>\u30a6\u30a3\u30f3\u30c9\u30a6\u95a2\u6570&nbsp;<\/p>\n<p>\u30d3\u30b8\u30d3\u30ea\u30c6\u30a3\u30de\u30c3\u30d7<\/p>\n<p>\u30d5\u30ea\u30fc\u30b9\u30da\u30fc\u30b9\u30de\u30c3\u30d7\u306e\u30e1\u30e2\u30ea\u8a2d\u5b9a\u306e\u81ea\u52d5\u5316<\/p>\n<p>GIN\u30a4\u30f3\u30c7\u30c3\u30af\u30b9<\/td>\n<\/tr>\n<tr>\n<td>9.0<\/td>\n<td>2010\/09\/20<\/td>\n<td>\u30db\u30c3\u30c8\u30b9\u30bf\u30f3\u30d0\u30a4&nbsp;<\/p>\n<p>\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u6a5f\u80fd<\/td>\n<\/tr>\n<tr>\n<td>9.1<\/td>\n<td>2011\/09\/12<\/td>\n<td>\u540c\u671f\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u6a5f\u80fd<\/td>\n<\/tr>\n<tr>\n<td>9.2<\/td>\n<td>2012\/09\/10<\/td>\n<td>\u30ab\u30b9\u30b1\u30fc\u30c9\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u6a5f\u80fd&nbsp;<\/p>\n<p>JSON\u578b,\u7bc4\u56f2\u578b\u306e\u8ffd\u52a0<\/p>\n<p>Index-only scan<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Index-only scan \u3068\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u306e\u5f8c\u306e\u30bb\u30c3\u30b7\u30e7\u30f3\u3067\u8a73\u3057\u304f\u53d6\u308a\u4e0a\u3052\u307e\u3057\u305f\u3002<\/p>\n<h2>Index Only Scan<\/h2>\n<p>Index Only Scan\u306f\u6751\u4e0a\u3055\u3093\u3067\u3059\u3002<\/p>\n<p>BLOG\u3067\u3082\u9023\u8f09\u3057\u305f\u5185\u5bb9\u3092\u767a\u8868\u3057\u3066\u3044\u305f\u3060\u304d\u307e\u3057\u305f\u3002<\/p>\n<p>Index Only Scan\u306e\u5185\u5bb9\u3068\u30c7\u30e2\u3092\u307e\u3058\u3048\u305f\u767a\u8868\u3067\u3057\u305f\u3002<\/p>\n<p>\u4ee5\u4e0bBLOG\u306e\u30ea\u30f3\u30af\u3067\u3059\u3002<\/p>\n<ul>\n<li><a title=\"PostgreSQL Index Only Scan \u596e\u95d8\u8a18 \u305d\u306e1\" href=\"http:\/\/www.techscore.com\/blog\/2013\/05\/27\/postgresql-index-only-scan-%e5%a5%ae%e9%97%98%e8%a8%98-%e3%81%9d%e3%81%ae1\/\">PostgreSQL Index Only Scan \u596e\u95d8\u8a18 \u305d\u306e1<\/a><\/li>\n<li><a title=\"PostgreSQL Index Only Scan \u596e\u95d8\u8a18 \u305d\u306e2\" href=\"http:\/\/www.techscore.com\/blog\/2013\/05\/30\/postgresql-index-only-scan-%e5%a5%ae%e9%97%98%e8%a8%98-%e3%81%9d%e3%81%ae2\/\">PostgreSQL Index Only Scan \u596e\u95d8\u8a18 \u305d\u306e2<\/a><\/li>\n<li><a title=\"PostgreSQL Index Only Scan \u596e\u95d8\u8a18 \u305d\u306e3\" href=\"http:\/\/www.techscore.com\/blog\/2013\/06\/07\/postgresql-index-only-scan-%e5%a5%ae%e9%97%98%e8%a8%98-%e3%81%9d%e3%81%ae3\/\">PostgreSQL Index Only Scan \u596e\u95d8\u8a18 \u305d\u306e3<\/a><\/li>\n<li><a title=\"PostgreSQL Index Only Scan \u596e\u95d8\u8a18 \u305d\u306e4\" href=\"http:\/\/www.techscore.com\/blog\/2013\/06\/19\/postgresql-index-only-scan-%e5%a5%ae%e9%97%98%e8%a8%98-%e3%81%9d%e3%81%ae4\/\">PostgreSQL Index Only Scan \u596e\u95d8\u8a18 \u305d\u306e4<\/a><\/li>\n<li><a title=\"PostgreSQL Index Only Scan \u596e\u95d8\u8a18 \u305d\u306e5\" href=\"http:\/\/www.techscore.com\/blog\/2013\/06\/20\/postgresql-index-only-scan-%e5%a5%ae%e9%97%98%e8%a8%98-%e3%81%9d%e3%81%ae5\/\">PostgreSQL Index Only Scan \u596e\u95d8\u8a18 \u305d\u306e5<\/a><\/li>\n<\/ul>\n<h2>\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3<\/h2>\n<p>\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306f\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u30a8\u30f3\u30b8\u30cb\u30a2\u306e\u91d1\u3055\u3093\u306b\u767a\u8868\u3057\u3066\u9802\u304d\u307e\u3057\u305f\u3002<br \/>\n\u5185\u5bb9\u306f<\/p>\n<ul>\n<li>\u30b9\u30c8\u30ea\u30fc\u30df\u30f3\u30b0\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u6a5f\u80fd\u306b\u3064\u3044\u3066\n<ul>\n<li>\u30d0\u30fc\u30b8\u30e7\u30f3\u6bce\u306e\u6a5f\u80fd\u30a2\u30c3\u30d7<\/li>\n<li>\u30b9\u30ec\u30fc\u30d6\u6d3b\u7528\u306e\u5229\u70b9<\/li>\n<\/ul>\n<\/li>\n<li>\u30b9\u30c8\u30ea\u30fc\u30df\u30f3\u30b0\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u7279\u5fb4\u306b\u3064\u3044\u3066\n<ul>\n<li>\u975e\u540c\u671f\/\u540c\u671f\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u6319\u52d5<\/li>\n<\/ul>\n<\/li>\n<li>\u6848\u4ef6\u3067\u306e\u63a1\u7528\u904e\u7a0b\u3067\u7fd2\u5f97\u3057\u305f\u5185\u5bb9\u306b\u3064\u3044\u3066\n<ul>\n<li>\u975e\u540c\u671f\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u904b\u7528\u6642\u306e\u6ce8\u610f\u70b9<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>\u3067\u3059\u3002<\/p>\n<p>\u30c7\u30e2\u3092\u307e\u3058\u3048\u3066\u306e\u767a\u8868\u3067\u3057\u305f\u3002<br \/>\n\u30c7\u30e2\u3067\u306f\u3001DB\u30b5\u30fc\u30d0\u30fc\u30922\u53f0(\u30de\u30b9\u30bf\u30fc\u3001\u30b9\u30ec\u30fc\u30d6)\u7528\u610f\u3057\u30011\u53f0(\u30b9\u30ec\u30fc\u30d6)\u306b\u969c\u5bb3\u3092\u767a\u751f\u3055\u305b\u305f\u6642\u306e\u6319\u52d5\u3084\u3001\u969c\u5bb3\u304b\u3089\u5fa9\u65e7\u3055\u305b\u305f\u6642\u306e\u6319\u52d5\u306e\u30c7\u30e2\u3092\u884c\u3044\u307e\u3057\u305f\u3002<\/p>\n<p>\u52c9\u5f37\u4f1a\u3067\u30c7\u30e2\u3092\u3059\u308b\u3068\u5931\u6557\u3059\u308b\u3053\u3068\u304c\u591a\u3044\u306e\u3067\u3059\u304c\u3001\u3053\u306e\u767a\u8868\u3067\u306f<strong>\u5b8c\u74a7\u306a\u30c7\u30e2<\/strong>\u3067\u3057\u305f\u3002<\/p>\n<h2>\u304a\u307e\u3051<\/h2>\n<h3>\u52c9\u5f37\u4f1a\u306e\u6e96\u5099\u4e2d\u306e\u69d8\u5b50<\/h3>\n<p>\u6e96\u5099\u3092\u5fc5\u6b7b\u3067\u3057\u3066\u308b\u91d1\u3055\u3093\u3068\u305d\u306e\u6a2a\u3067\u30d4\u30fc\u30b9\u3057\u3066\u308b\u6751\u4e0a\u3055\u3093\u3002<\/p>\n<p><a href=\"https:\/\/www.techscore.com\/blog\/wp\/wp-content\/uploads\/2013\/06\/36c8c9261c98e7c1b7d7d5e14410cdda.jpg\" rel=\"facebox\" rel=\"attachment wp-att-2913\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-2913\" alt=\"\u5199\u771f 1\" src=\"https:\/\/www.techscore.com\/blog\/wp\/wp-content\/uploads\/2013\/06\/36c8c9261c98e7c1b7d7d5e14410cdda.jpg\" width=\"640\" height=\"478\" \/><\/a><\/p>\n<h3>\u52c9\u5f37\u4f1a\u5f8c\u306e\u6253\u3061\u4e0a\u3052<\/h3>\n<p>\u52c9\u5f37\u4f1a\u5f8c\u306f\u767a\u8868\u80053\u4eba\u3068\u79c1\u3067\u8fd1\u304f\u306e\u5c45\u9152\u5c4b\u3067\u6253\u3061\u4e0a\u3052\u3067\u3059\u3002<br \/>\n\u3061\u306a\u307f\u306b4\u4eba\u3068\u3082\u4eca\u5e74\u4e09\u5341\u8def\u30c7\u30d3\u30e5\u30fc\u306e30\u6b73\u3067\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.techscore.com\/blog\/wp\/wp-content\/uploads\/2013\/06\/55610c25d628705bde31c82a4bd64fbf.jpg\" rel=\"facebox\" rel=\"attachment wp-att-2916\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-2916\" alt=\"\u5199\u771f 4\" src=\"https:\/\/www.techscore.com\/blog\/wp\/wp-content\/uploads\/2013\/06\/55610c25d628705bde31c82a4bd64fbf.jpg\" width=\"640\" height=\"478\" \/><\/a><\/p>\n<h2>\u3042\u3068\u304c\u304d<\/h2>\n<p>\u4eca\u56de\u306e\u52c9\u5f37\u4f1a\u306f\u521d\u306e\u30a4\u30f3\u30d5\u30e9\u7cfb\u306e\u52c9\u5f37\u4f1a\u3068\u3044\u3046\u3053\u3068\u3067\u3001\u30a2\u30d7\u30ea\u30c1\u30fc\u30e0\u306e\u30a8\u30f3\u30b8\u30cb\u30a2\u3060\u3051\u3058\u3083\u306a\u304f\u3001\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u30c1\u30fc\u30e0\u306e\u65b9\u3005\u306b\u3082\u305f\u304f\u3055\u3093\u53c2\u52a0\u3057\u3066\u3044\u305f\u3060\u304d\u307e\u3057\u305f\u3002<br \/>\n\u305f\u3076\u3093\u4eca\u307e\u3067\u3067\u4e00\u756a\u53c2\u52a0\u8005\u304c\u591a\u304b\u3063\u305f\u6c17\u304c\u3057\u307e\u3059\u3002<\/p>\n<p>\u3044\u3064\u3082\u306f\u76f4\u524d\u3067\u52c9\u5f37\u4f1a\u306e\u6e96\u5099\u3092\u3059\u308b\u3053\u3068\u304c\u591a\u304b\u3063\u305f\u306e\u3067\u3059\u304c\u3001\u4eca\u56de\u306f\u30c7\u30e2\u304c\u30e1\u30a4\u30f3\u3068\u3044\u3046\u3053\u3068\u3082\u3042\u308a\u30011\u30f6\u6708\u524d\u304b\u6e96\u5099\u3092\u59cb\u3081\u305f\u306e\u3067\u3001\u305d\u3053\u305d\u3053\u4f59\u88d5\u3092\u6301\u3063\u3066\u52c9\u5f37\u4f1a\u306b\u671b\u3081\u307e\u3057\u305f\u3002<br \/>\n\u3084\u3063\u3071\u308a\u4e8b\u524d\u6e96\u5099\u306f\u5927\u4e8b\u3067\u3059\u306d\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3053\u3093\u306b\u3061\u306f\u3001\u9234\u6728\u3067\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\u5148\u65e5\u884c\u3063\u305f\u793e\u5185 PostgreSQL \u52c9\u5f37\u4f1a\u3092\u30ec\u30dd\u30fc\u30c8\u3057\u307e\u3059\uff01<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>\u4eca\u307e\u3067\u306e\u793e\u5185\u52c9\u5f37\u4f1a\u306f\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u5bc4\u308a\u306e\u5185\u5bb9\u304c\u591a\u304b\u3063\u305f\u306e\u3067\u3059\u304c\u3001<\/p>\n<p>\u4eca\u56de\u306f\u30a4\u30f3\u30d5\u30e9\u306e\u65b9\u306b\u3082\u767a\u8868\u306b\u53c2\u52a0\u3057\u3066\u3044\u305f\u3060\u304d\u307e\u3057\u305f\u3002<br \/><a href=\"https:\/\/www.techscore.com\/blog\/2013\/06\/27\/%e7%a4%be%e5%86%85-postgresql-%e5%8b%89%e5%bc%b7%e4%bc%9a%e3%83%ac%e3%83%9d%e3%83%bc%e3%83%88\/\">\u7d9a\u304d\u3092\u8aad\u3080...<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[41],"tags":[206],"_links":{"self":[{"href":"https:\/\/www.techscore.com\/blog\/wp-json\/wp\/v2\/posts\/2876"}],"collection":[{"href":"https:\/\/www.techscore.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.techscore.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.techscore.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.techscore.com\/blog\/wp-json\/wp\/v2\/comments?post=2876"}],"version-history":[{"count":1,"href":"https:\/\/www.techscore.com\/blog\/wp-json\/wp\/v2\/posts\/2876\/revisions"}],"predecessor-version":[{"id":17922,"href":"https:\/\/www.techscore.com\/blog\/wp-json\/wp\/v2\/posts\/2876\/revisions\/17922"}],"wp:attachment":[{"href":"https:\/\/www.techscore.com\/blog\/wp-json\/wp\/v2\/media?parent=2876"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.techscore.com\/blog\/wp-json\/wp\/v2\/categories?post=2876"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.techscore.com\/blog\/wp-json\/wp\/v2\/tags?post=2876"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}