{"published":"2016-05-06 12:17:08","provider_name":"Hatena Blog","type":"rich","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fa4dosanddos.hatenablog.com%2Fentry%2F2016%2F05%2F06%2F121708\" title=\"pg_repack \u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb - \u30d7\u30ed\u30b0\u30e9\u30e0\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","version":"1.0","image_url":null,"categories":["PostgreSQL"],"width":"100%","title":"pg_repack \u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb","author_url":"https://blog.hatena.ne.jp/a4dosanddos/","description":"\u308f\u3051\u3042\u3063\u3066 PostgreSQL \u62e1\u5f35\u306e pg_repack \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u307f\u305f\u306e\u3067\u30e1\u30e2\u3092\u6b8b\u3057\u3066\u304a\u304d\u307e\u3059\u3002DB\u307e\u308f\u308a\u306f\u9580\u5916\u6f22\u3067\u3059\u304c\u3001\u307e\u3041\u3001\u6700\u5c0f\u9650\u306e\u30ed\u30c3\u30af\u3067\u30c6\u30fc\u30d6\u30eb\u306e\u518d\u7de8\u6210\u3092\u3057\u3066\u304f\u308c\u308b\u3082\u306e\u307f\u305f\u3044\u3067\u3059\u3002PostgreSQL \u306b\u306f CLUSTER \u3084 VACUUM FULL \u3063\u3066\u3082\u306e\u304c\u3042\u308a\u307e\u3059\u304c\u3001\u3053\u306e\u3042\u305f\u308a\u306e\u6a5f\u80fd\u306f ACCESS EXCLUSIVE \u3068\u3044\u3046\u4e00\u756a\u5f37\u3044\u30ed\u30c3\u30af\u3092\u53d6\u308b\u306e\u3067\u30aa\u30f3\u30e9\u30a4\u30f3\u72b6\u614b\u3067\u306f\u5b9f\u65bd\u3067\u304d\u306a\u3044\u307f\u305f\u3044\u3067\u3059\u3002GitHub - reorg/pg_repack: Reorganize tables in PostgreSQL databases with minimal lockspg_\u2026","blog_url":"https://a4dosanddos.hatenablog.com/","blog_title":"\u30d7\u30ed\u30b0\u30e9\u30e0\u65e5\u8a18","url":"https://a4dosanddos.hatenablog.com/entry/2016/05/06/121708","height":"190","provider_url":"https://hatena.blog","author_name":"a4dosanddos"}