{"id":255,"date":"2007-06-05T23:29:00","date_gmt":"2007-06-05T14:29:00","guid":{"rendered":"https:\/\/www.picolix.jp\/blog\/2007\/06\/postgres-db.html\/"},"modified":"2019-04-02T10:25:53","modified_gmt":"2019-04-02T01:25:53","slug":"postgres-db","status":"publish","type":"post","link":"https:\/\/www.picolix.jp\/blog\/2007\/06\/postgres-db.html","title":{"rendered":"\u7a81\u7136Postgres DB\u304c\u9045\u304f\u306a\u3063\u305f\u3002"},"content":{"rendered":"<p>\u3053\u306e\u30b5\u30fc\u30d0\u306ePostgres\u3067\u3059\u304c\u3001\u6700\u8fd1\u3059\u3054\u304f\u9045\u304f\u306a\u3063\u305f\u3002<br \/>select count(*) from xxxxx<br \/>\u3067\u305f\u304b\u3060\u304b\uff11\uff10\uff10\uff10\u4ef6\u7a0b\u5ea6\u306e\u30ec\u30b3\u30fc\u30c9\u306a\u306e\u306b\uff11\uff14\u79d2\u3082\u304b\u304b\u3063\u3066\u3057\u307e\u3063\u3066\u3044\u308b\u3002<br \/>\u3082\u3046\uff11\u56de\u3059\u308b\u3068\uff14\u79d2\u3001\u3055\u3089\u306b\u3082\u3046\u4e00\u56de\u3059\u308b\u3068\uff12\u79d2\u3002\u591a\u5206\u30ad\u30e3\u30c3\u30b7\u30e5\u306b\u5165\u3063\u3066\u30d2\u30c3\u30c8\u3057\u3066\u3044\u308b\u306e\u3060\u3068\u601d\u3046\u304c\u305d\u308c\u306b\u3057\u3066\u3082\u9045\u3059\u304e\u3001REINDEX\u3068\u304bVACCUM\u306f\u3084\u3063\u3066\u307e\u3059\u304c\u52b9\u679c\u306a\u3057\u3002<br \/>\u305d\u3053\u3067\u3001vacuum full analyze\u3092\u5b9f\u65bd\u3057\u305f\u3068\u3053\u308d\u3001\u5287\u7684\u306b\u6539\u5584\u3055\u308c\u307e\u3057\u305f\u3002\u524d\u8ff0\u306e\u5b9f\u884c\u901f\u5ea6\u304c\u30014msec\u306b\u306a\u3063\u305f\u3002<br \/>\u6570\u5341\u4e07\u4ef6\u306e\u8868\u306eupdate,delete\u3092\u7e70\u308a\u8fd4\u3057\u3066\u3044\u308b\u3046\u3061\u306b\u3001\u7121\u99c4\u306a\u9818\u57df\u304c\u5897\u3048\u3066\u3057\u307e\u3063\u305f\u3088\u3046\u3067\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3053\u306e\u30b5\u30fc\u30d0\u306ePostgres\u3067\u3059\u304c\u3001\u6700\u8fd1\u3059\u3054\u304f\u9045\u304f\u306a\u3063\u305f\u3002select count(*) from xxxxx\u3067\u305f\u304b\u3060\u304b\uff11\uff10\uff10\uff10\u4ef6\u7a0b\u5ea6\u306e\u30ec\u30b3\u30fc\u30c9\u306a\u306e\u306b\uff11\uff14\u79d2\u3082\u304b\u304b\u3063\u3066\u3057\u307e\u3063\u3066\u3044\u308b\u3002\u3082\u3046\uff11\u56de\u3059\u308b\u3068\uff14\u79d2\u3001\u3055\u3089\u306b\u3082\u3046\u4e00\u56de\u3059\u308b\u3068 &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.picolix.jp\/blog\/2007\/06\/postgres-db.html\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;\u7a81\u7136Postgres DB\u304c\u9045\u304f\u306a\u3063\u305f\u3002&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[16],"_links":{"self":[{"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/posts\/255"}],"collection":[{"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/comments?post=255"}],"version-history":[{"count":1,"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/posts\/255\/revisions"}],"predecessor-version":[{"id":1129,"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/posts\/255\/revisions\/1129"}],"wp:attachment":[{"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/media?parent=255"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/categories?post=255"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/tags?post=255"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}