[B! ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹] cl-gakuã®ãƒ

cl-gaku id:cl-gaku

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã™ã‚‹cl-gakuã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

PostgreSQLã«é–¢ã™ã‚‹NTTãƒ‡ãƒ¼ã‚¿ã®SlideShareã®ã‚¹ãƒ©ã‚¤ãƒ‰ãƒªã‚¹ãƒˆ
ã¯ã˜ã‚ã« SlideShareã®åºƒå‘Šå¯¾ç–ã§ã™ã€‚ æ›´æ–°å±¥æ´ 2023/12/13 CloudNative Days Tokyo 2023ã®è³‡æ–™ã‚’è¿½åŠ ã—ã¾ã—ãŸã€‚ 2023/12/07 PostgreSQL Conference Japan 2023ã®è³‡æ–™ã‚’è¿½åŠ ã—ã¾ã—ãŸã€‚ 2023/11/16 NTTãƒ‡ãƒ¼ã‚¿ã§ä»¥å‰ä½¿ã‚ã‚Œã¦ã„ãŸSlideShareã®ã‚¹ãƒ©ã‚¤ãƒ‰ã‚’è¿½åŠ ã—ã¾ã—ãŸã€‚ 2024/03/08 ç¬¬45å›žPostgreSQLã‚¢ãƒ³ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹@ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã€DEIM2024ã®è³‡æ–™ã‚’è¿½åŠ ã—ã¾ã—ãŸã€‚ 2024/07/09 OCHaCafe Season 8 #4ã€DSS Asia 2024ã€TiUG Meetup #2ã€ç¬¬47å›žPostgreSQLã‚¢ãƒ³ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹@ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã®è³‡æ–™ã‚’è¿½åŠ ã—ã¾ã—ãŸã€‚ 2024 pg_stat_activityã®ä¸å¯è§£ãªè¦³æ¸¬çµæžœã®è¬Ž (ç¬¬47å›ž PostgreSQLã‚¢ãƒ³ã‚«ãƒ³
cl-gaku 2024/08/18
ã‚ã¨ã§èªã‚€

postgresql

postgres

SQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
è«–ç†å‰Šé™¤ãƒ•ãƒ©ã‚°ã¨ã„ã†åã®æ»äº¡ãƒ•ãƒ©ã‚° - @ledsun blog
RDB - DELETE_FLAG ã‚’ä»˜ã‘ã‚‹å‰ã«ç¢ºèªã—ãŸã„ã“ã¨ã€‚ - Qiita è«–ç†å‰Šé™¤ãŒäº‘ã€…ã«ã¤ã„ã¦ - mike-neckã®ãƒ–ãƒã‚° Kazuho's Weblog: è«–ç†å‰Šé™¤ã¯ãªãœã€Œç‹ãŒæ‚ªã„ã€ã‹ æµè¡Œã£ã¦ã„ã‚‹ã®ã§ä¹—ã£ã‹ã‚Šã¾ã™ã€‚ çµè«– ã€Œãƒ‡ãƒ¼ã‚¿åˆ¶ç´„ã®å¼·åŠ›ã•ã¨é›†åˆã¨ã—ã¦ã®è¡¨ç¾åŠ›ã‚’æ¨ã¦ãªãŒã‚‰ã€Relational Databaseã‚’ä½¿ã†ã®ã¯ãªãœã‹ï¼Ÿã€ è«–ç†å‰Šé™¤ãƒ•ãƒ©ã‚°ã®ãƒ‡ãƒ¡ãƒªãƒƒãƒˆ å¤§ä½“ä¸‰ã¤ã‚ã‚‹ã¨è€ƒãˆã¦ã„ã¾ã™ã€‚ ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®è¨€è‘‰ã§ãªã„ ãƒ‡ãƒ¼ã‚¿åˆ¶ç´„ã®å¼±ã• é›†åˆã¨ã—ã¦èªè˜ã§ããªã„ ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®è¨€è‘‰ã§ãªã„ ç§ã®çµŒé¨“ä¸Šã¯ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‹ã‚‰ã€Œè«–ç†å‰Šé™¤ã€ã¨ã„ã†è¨€è‘‰ã‚’èžã„ãŸã“ã¨ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ æ¬¡ã®ã‚ˆã†ãªè¦ä»¶ã¯ã€èžã„ãŸã“ã¨ãŒã‚ã‚Šã¾ã™ ç¤¾å“¡ãŒé€€è·ï¼ˆãƒ»è»¢å±žï¼‰ã™ã‚‹ ï¼ˆå£²æŽ›é‡‘ã®å›žåŽã‚’è«¦ã‚ã¦ï¼‰å£²ä¸Šã‚’æ‰“ã¡æ¶ˆã™ ã€ŒãŠçŸ¥ã‚‰ã›ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã€ã‚’å…¬é–‹æ—¥ãŒãã‚‹ã¾ã§éžè¡¨ç¤ºã«ã™ã‚‹ æ—¢èªãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚’è¡¨ç¤ºã—ãªã„ ä¿å˜æœŸé–“ãŒéŽãŽãŸã‚¢ãƒ³ã‚±ãƒ¼ãƒˆçµæžœã‚’ã‚ªãƒšãƒ¬
cl-gaku 2020/10/08
database

db

è«–ç†å‰Šé™¤

è¨è¨ˆ

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
è«–ç†å‰Šé™¤ãŒäº‘ã€…ã«ã¤ã„ã¦ - mike-neckã®ãƒ–ãƒã‚°
ä»Šæ—¥æœã‚¤ãƒã§è¦‹ãŸã‚¨ãƒ³ãƒˆãƒªãƒ¼ãŒã“ã‚Œã§ã—ãŸã€‚ qiita.com è«–ç†å‰Šé™¤ã®å¼Šå®³ã¯è‰²ã€…ãªã¨ã“ã‚ã§è¨€ã‚ã‚Œã¦ã„ã‚‹ã‘ã©ã€åƒ•ã®è¶³ã‚Šãªã„é ã§ç†è§£ã—ã¦ã„ã‚‹æ‰€ã«ã‚ˆã‚‹ã¨ã€äºŒã¤ã®å€¤ã—ã‹æŒãŸãªã„å‰Šé™¤ãƒ•ãƒ©ã‚°çš„ãªã‚‚ã®ã¯ã‚«ãƒ¼ãƒ‡ã‚£ãƒŠãƒªãƒ†ã‚£ãŒäº‘ã€…ã§æ¤œç´¢æ¡ä»¶ã«ã¤ã‘ã¦ã‚‚æ€§èƒ½ä¸Šçš„ã«ã‚‚ã‚ˆããªã„ã—ã€æ„å‘³ãŒãªã„ã¨ã„ã†ã“ã¨ã§ã™ã€‚ è«–ç†å‰Šé™¤ã‚’å®Œå…¨ã«æ‚ªã ã¨ã¯è¨€ã„ã¾ã›ã‚“ãŒã€è«–ç†å‰Šé™¤ã‚’æ¥µåŠ›æŽ’ã—ãŸã„äººãŸã¡ã¯ã€åŸºæœ¬çš„ã«ãƒ‡ãƒ¼ã‚¿ãã®ã‚‚ã®ã‚’å‰Šé™¤ã™ã‚‹ã€ã‚‚ã—ãã¯è«–ç†å‰Šé™¤ã¨ã„ã†ã®ã¯ã¾ã è¦ä»¶çš„ã«æœªç¢ºå®šãªè¦ç´ ãŒéš ã•ã‚Œã¦ã„ã‚‹ã“ã¨ã‚’ç¤ºã™ãƒ•ãƒ©ã‚°ã§ã‚ã‚‹ã¨è€ƒãˆã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ åƒ•ãŒITã®æ¥ç•Œã§ã‚ãƒ£ãƒªã‚¢ã‚’ã‚¹ã‚¿ãƒ¼ãƒˆã—ã¦ã‹ã‚‰2å¹´ç›®ãã‚‰ã„ã«é…ç½®ã•ã‚ŒãŸãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã¯Tå—åž‹ERæ‰‹æ³•ã¨ã„ã†ã®ã‚’ãƒ™ãƒ¼ã‚¹ã«ã—ãŸãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã‚’ã—ã¦ã„ã¦ã€ãã“ã§ã‹ãªã‚Šé›ãˆã‚‰ã‚ŒãŸã‚ã‘ã§ã™ãŒã€ãã®æ™‚ã«ã¯ã ã„ãŸã„ã“ã®ã‚ˆã†ãªåŽŸå‰‡ã‚’å©ãã“ã¾ã‚Œã¾ã—ãŸã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã«çŠ¶æ…‹ã‚’æŒãŸã›ãªã„ ç©¶æ¥µã«ã¯æ©Ÿæ¢°ãŒèªè˜ã™ã‚‹ã‚ãƒ¼ã¨ã€äººé–“ã«ã¨ã£ã¦æ„
cl-gaku 2020/07/06
db

database

è¨è¨ˆ

è«–ç†å‰Šé™¤

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
è«–ç†å‰Šé™¤ã¯ãªãœã€Œç‹ãŒæ‚ªã„ã€ã‹
ã€Œè«–ç†å‰Šé™¤ãŒäº‘ã€…ã«ã¤ã„ã¦ - mike-neckã®ãƒ–ãƒã‚°ã€ã‚’èªã‚“ã§ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã«ãŠã„ã¦ã€ã€Œãƒ†ãƒ¼ãƒ–ãƒ«ã®æ›¸ãæ›ãˆã‚’ã™ã‚‹ãªã€immutableãªãƒžã‚¹ã‚¿ã¨æ›´æ–°ãƒã‚°ã«ã‚ˆã£ã¦å…¨ã¦ã‚’æ§‹æˆã—ã‚ã€ã¨ã„ã†ã“ã®è¨˜äº‹ã®ä¸»å¼µã¯ãƒ¢ãƒ‡ãƒªãƒ³ã‚°è«–ã¨ã—ã¦å…¨ãæ£ã—ã„ã€‚ ã ãŒã€æ®‹å¿µãªã“ã¨ã«ã€ãƒ‡ã‚£ã‚¹ã‚¯ã‚„ãƒ¡ãƒ¢ãƒªãŒè²´é‡ãªè³‡æºã ã£ãŸæ™‚ä»£ã®æŠ€è¡“ã§ã‚ã‚‹RDBã¯ã€ãã®ã‚ˆã†ãªãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã«åŸºã¥ã„ã¦è¨è¨ˆã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¯å¿…ãšã—ã‚‚é©ã—ã¦ã„ãªã„ã€‚ ç¬¬ä¸€ã®å•é¡Œã¯ã€RDBã«å¯¾ã—ã¦ãªã•ã‚Œã‚‹æ§˜ã€…ãªã€Œæ›´æ–°ã€ï¼ˆãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ï¼‰ã¯ä¸å®šå½¢ï¼ˆã©ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã©ã®ã‚ˆã†ã«ä¿®æ£ã™ã‚‹ã‹ã¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ä¾å˜ï¼‰ã ã¨ã„ã†ç‚¹ã€‚ä¸å®šå½¢ãªã€Œæ›´æ–°ã€ã‚’æ™‚ç³»åˆ—ã«ãã£ã¦RDBã«è¨˜éŒ²ã—ã¦ã„ãã®ã¯ã€è¨è¨ˆã¨ä¸¦èµ°æ€§ã®ç‚¹ã«ãŠã„ã¦å›°é›£ã‚ã‚‹ã„ã¯ç…©é›‘ãªã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãŒå¿…è¦ã«ãªã‚‹ï¼ˆã¨ã„ã†ã‹ã€ãã®ã‚ˆã†ãªã€Œã‚¤ãƒ™ãƒ³ãƒˆã€ã«ã‚ˆã‚‹ã€Œå¤‰åŒ–ã€ã¯REDOãƒã‚°ã«æ›¸ãã€ãã®æ›´æ–°ã•ã‚ŒãŸã€ŒçŠ¶æ…‹ã€ã‚’ãƒ†ãƒ¼ãƒ–ãƒ«ã«åæ˜ ã—ã¦ã„ãã¨ã„ã†ã®ãŒ
cl-gaku 2020/07/06
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

è«–ç†å‰Šé™¤

è¨è¨ˆ

db

database

Immutable
ãƒªãƒ³ã‚¯
1