[B! postgresql] jitsu102ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

jitsu102 id:jitsu102

postgresqlã«é–¢ã™ã‚‹jitsu102ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (9)

${{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}}

Traditional Databases in Kubernetes
describes how traditional databases like postgresql clusters are redesigned to run it on Kubernetes to suites CloudNative nature.
jitsu102 2020/04/12
kubernetes

k8s

postgresql
ãƒªãƒ³ã‚¯
ã¤ã‚‰ããªã„ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ã‚·ãƒ¼ã‚’æ±‚ã‚ã¦: å…¨ã¦è¦‹ã›ã¾ã™ï¼ SmartHR ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç§»è¡Œãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®è£å´ / builderscon 2018
ã¤ã‚‰ããªã„ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ã‚·ãƒ¼ã‚’æ±‚ã‚ã¦: å…¨ã¦è¦‹ã›ã¾ã™ï¼ SmartHR ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç§»è¡Œãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®è£å´ / buildersconÂ 2018
jitsu102 2018/09/11
builderscon

builderscon2018

mysql

postgresql

migration
ãƒªãƒ³ã‚¯
PostgreSQL 11 æ¤œè¨¼å ±å‘Š
2018å¹´5æœˆ24æ—¥ã«beta1ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸ PostgreSQL 11 ã®ä¸»è¦ãªæ–°æ©Ÿèƒ½ã«ã¤ã„ã¦å‹•ä½œæ¤œè¨¼ã‚’è¡Œã£ãŸçµæžœã‚’å ±å‘Šã—ã¾ã™ã€‚ æœ¬æ¤œè¨¼ãƒ¬ãƒãƒ¼ãƒˆã¯ ã‚³ãƒžãƒ³ãƒ‰å®Ÿè¡Œæ‰‹é †ã‚‚è©³ç´°ã«è¨˜è¼‰ã—ã¦ã„ã¾ã™ã®ã§ã€PostgreSQL 11 ã‚’ä½¿ã£ã¦å®Ÿéš›ã«æ–°æ©Ÿèƒ½ã‚’ç¢ºèªã—ãŸã„æ–¹ã®ã‚¬ã‚¤ãƒ‰ãƒ–ãƒƒã‚¯ã¨ã—ã¦ã‚‚æ´»ç”¨ã§ãã¾ã™ã€‚ PostgreSQL 11 ã®ä¸»è¦ãªå¼·åŒ–ç‚¹ã¯ä»¥ä¸‹ã®é€šã‚Šã§ã™ã€‚ JITã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã®è¿½åŠ ï¼»æ€§èƒ½ï¼½ ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã®æ§˜ã€…ãªæ”¹å–„ï¼»æ©Ÿèƒ½ï¼‹æ€§èƒ½ï¼½ ä¸¦åˆ—å®Ÿè¡Œã®æ§˜ã€…ãªæ”¹å–„ï¼»æ€§èƒ½ï¼½ ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£å†…ã§ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ¶å¾¡ã‚’ã‚µãƒãƒ¼ãƒˆ ï¼»æ©Ÿèƒ½ï¼½ èªè¨¼ã§SCRAMãƒãƒ£ãƒ³ãƒãƒ«ãƒã‚¤ãƒ³ãƒ‰ã‚’ã‚µãƒãƒ¼ãƒˆï¼»ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ï¼½ ALTER TABLE .. ADD COLUMN ã®æ€§èƒ½æ”¹å–„ ï¼»æ€§èƒ½ï¼½ ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦é–¢æ•°ã®æ‹¡å¼µï¼»æ©Ÿèƒ½ï¼½ ä¸Šè¨˜ã®è§’æ‹¬å¼§ï¼»ï¼½å†…ã®è¨˜è¼‰ã¯ä½•ã«å¯„ä¸Žã™ã‚‹å¼·åŒ–ç‚¹ã§ã‚ã‚‹ã‹ã‚’ç¤ºã—ã¦ã„ã¾ã™ã€‚å¤§è¦æ¨¡ãªãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†å ´åˆã«ã¯æœ€åˆã®ï¼“
jitsu102 2018/07/28
postgresql
ãƒªãƒ³ã‚¯
ã“ã®é€£ä¼‘ã®èªæ›¸ã«ã‚ªã‚¹ã‚¹ãƒ¡ã®ä¸€å†Šã€ŒSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ï¼ˆå‰²å¼•ã‚³ãƒ¼ãƒ‰ã‚ã‚Šï¼‰
æœ€è¿‘ã€ä¹…ã—ã¶ã‚Šã«PostgreSQLã®ã‚¯ã‚¨ãƒªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ã—ã¦ã„ãŸã®ã§ã™ãŒã€ãã®éŽç¨‹ã§ã€Œã“ã®æœ¬ã¯ãœã²ã‚‚ã£ã¨å¤šãã®äººã«èªã‚“ã§ã‚‚ã‚‰ã„ãŸã„ã€ã¨æ”¹ã‚ã¦æ€ã„å‡ºã—ãŸä¸€å†ŠãŒã‚ã‚Šã¾ã—ãŸã€‚ ãã‚Œã¯ã€ã€ŒSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ï¼ˆåŽŸé¡Œï¼šSQL Performance Explainedï¼‰ã€ã¨ã„ã†æœ¬ã§ã™ã€‚ SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ http://sql-performance-explained.jp/ ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ç‰¹ã«ã‚¯ã‚¨ãƒªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã¤ã„ã¦èª¬æ˜Žã™ã‚‹å ´åˆã€ãã®å‰æã¨ãªã‚‹çŸ¥è˜ã¯åºƒç¯„ãªã‚‚ã®ã«ãªã‚Šã¾ã™ã€‚ ãã®ãŸã‚ã€è‡ªåˆ†ãŒé ‘å¼µã£ã¦èª¬æ˜Žã™ã‚‹ã‚ˆã‚Šã‚‚ã€å„ªã‚ŒãŸã‚¨ã‚ã‚¹ãƒ‘ãƒ¼ãƒˆã®ã¾ã¨ã‚ãŸã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã‚’æ´»ç”¨ã•ã›ã¦ã‚‚ã‚‰ã†æ–¹ãŒã€è³ªãƒ»é‡ã¨ã‚‚ã«å„ªã‚ŒãŸã‚¤ãƒ³ãƒ—ãƒƒãƒˆã«ã—ã¦ã„ãŸã ã‘ã‚‹ã®ã§ã¯ãªã„ã‹ã€ã¨æ€ã†ã®ã§ã™ã€‚ ã¾ãŸã€ã“ã®ã€ŒSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã¯éžå¸¸ã«è‰¯ã„æœ¬ã§ã‚ã‚‹ã«ã‚‚é–¢ã‚ã‚‰ãšã€ä¸€èˆ¬ã®å‡ºç‰ˆç¤¾ã‹ã‚‰å‡ºã¦ã„ã‚‹ã‚ã‘ã§ã¯ãªã„ãŸã‚ã€ãã‚Œã»ã©ç©
jitsu102 2018/04/25
mysql

postgresql

sql

database
ãƒªãƒ³ã‚¯
é€²æ—ï¼‰SSD-to-GPU ãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆSQLå®Ÿè¡Œæ©Ÿèƒ½ - KaiGaiã®ä¿ºãƒ¡ãƒ¢
ã“ã“æš«ããƒ–ãƒã‚°ã§ã¾ã¨ã‚ã¦ã„ãªã‹ã£ãŸã€SSD-to-GPUãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆSQLå®Ÿè¡Œæ©Ÿèƒ½ã®é€²æ—ã«ã¤ã„ã¦ã€‚ ã“ã®æ©Ÿèƒ½ã‚’ã‹ã„ã¤ã¾ã‚“ã§è¨€ã†ã¨ã€NVMe-SSDã«æ ¼ç´ã•ã‚Œã¦ã„ã‚‹PostgreSQLã®ãƒ‡ãƒ¼ã‚¿ãƒ–ãƒãƒƒã‚¯ã‚’GPU RAMã«ç›´æŽ¥è»¢é€ã—ã€ãã“ã§SQLã®WHEREå¥/JOIN/GROUP BYã‚’å®Ÿè¡Œã™ã‚‹ã“ã¨ã§è¦‹ã‹ã‘ä¸Šã®I/Oé‡ã‚’å‰Šæ¸›ã™ã‚‹ã¨ã„ã†ä»£ç‰©ã§ã‚ã‚‹ã€‚ NVIDIAã®Tesla/Quadro GPUãŒå¯¾å¿œã™ã‚‹GPUDirect RDMAæ©Ÿèƒ½ã‚’ä½¿ã„ã€SSD<=>GPUé–“ã®ãƒ‡ãƒ¼ã‚¿è»¢é€ã‚’ä»²ä»‹ã™ã‚‹Linux kernel moduleã‚’ä½¿ãˆã°ã€CPU/RAMã«ãƒ‡ãƒ¼ã‚¿ã‚’ãƒãƒ¼ãƒ‰ã™ã‚‹å‰ã«GPUä¸Šã§ã®å‡¦ç†ã‚’è¡Œã†ã“ã¨ãŒã§ãã‚‹ã€‚ ã—ã°ã‚‰ãå‰ã‹ã‚‰Scanç³»ã®å‡¦ç†ã«ã¯å¯¾å¿œã—ã¦ã„ãŸãŒã€JOIN/GROUP BYã¸ã®å¯¾å¿œã‚’åŠ ãˆã€ã•ã‚‰ã«PostgreSQL v9.6ã®CPUä¸¦åˆ—ã«ã‚‚è¿½å¾“ã—ãŸã¨ã„ã†ã“ã¨ã§ã€ç°¡å˜ãªãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãªã‚‰å–ã‚Œã‚‹
jitsu102 2017/04/25
gpu

ssd

postgresql

performance
ãƒªãƒ³ã‚¯
GitLab.comãŒæ“ä½œãƒŸã‚¹ã§æœ¬ç•ªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å–ªå¤±ã€‚5ã¤ã‚ã£ãŸã¯ãšã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ‰‹æ®µã¯å½¹ç«‹ãŸãšã€é ¼ã¿ã®ç¶±ã¯6æ™‚é–“å‰ã«å¶ç„¶å–ã£ãŸã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆ ï¼ Publickey
æžœãŸã—ã¦GitLab.comã§ä½•ãŒèµ·ããŸã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ã“ã‚Œã¾ã§ã®çµŒç·¯ã‚’ã¾ã¨ã‚ã¾ã—ãŸã€‚ ã‚¹ãƒ‘ãƒ ã«ã‚ˆã‚‹ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ã®ã‚¹ãƒ‘ã‚¤ã‚¯ã‹ã‚‰ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä¸èª¿ã¸ GitLab.comã¯ä»Šå›žã®ã‚¤ãƒ³ã‚·ãƒ‡ãƒ³ãƒˆã«ã¤ã„ã¦ã®è©³ç´°ãªçµŒéŽã‚’ã€ŒGitLab.com Database Incident - 2017/01/31ã€ã§å…¬é–‹ã—ã¦ã„ã¾ã™ã€‚ã¾ãŸã€ã‚‚ã†å°‘ã—æ•´ç†ã•ã‚ŒãŸæƒ…å ±ãŒãƒ–ãƒã‚°ã€ŒGitLab.com Database Incident | GitLabã€ã«ã‚‚æŽ²è¼‰ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã“ã‚Œã‚‰ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’è»¸ã«ã€ä¸»ãªã§ãã”ã¨ã‚’æ™‚ç³»åˆ—ã«è¦‹ã¦ã„ãã¾ã—ã‚‡ã†ã€‚ 1æœˆ31æ—¥16æ™‚ï¼ˆä¸–ç•Œå”å®šæ™‚ã€‚æ—¥æœ¬æ™‚é–“2æœˆ1æ—¥åˆå‰8æ™‚ï¼‰ã€YPæ°ï¼ˆYorick Peterseæ°ã¨æ€ã‚ã‚Œã‚‹ï¼‰ã¯PostgreSQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’è¨å®šã™ã‚‹ãŸã‚ã«ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã®è«–ç†ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆã‚’ä½œæˆã€‚ã“ã‚ŒãŒã‚ã¨ã§å¤±ã‚ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’æ•‘ã†å¹¸é‹ã«ã¤ãªãŒã‚Šã¾ã™ã€‚ 1æœˆ31æ—¥21æ™‚
jitsu102 2017/02/06
ã“ã¡ã‚‰ã‚‚å‚ç…§ https://about.gitlab.com/2017/02/01/gitlab-dot-com-database-incident/ https://goo.gl/3g4384 https://togetter.com/li/1076845

git

gitlab

postgresql
ãƒªãƒ³ã‚¯
Uberã®Postgresqlã‹ã‚‰NoSQL on MySQLã¸ã®ç§»è¡Œã‚’èªã‚“ã§ã–ã£ãã‚Šã¾ã¨ã‚ãŸ
Uber-migrated-pg-to-mysql.md Why Uber Engineering Switched from Postgres to MySQL - Uber Engineering Blog ã®ã¾ã¨ã‚ Posgresqlã ã¨ pgã¯è¿½è¨˜åž‹ãªã®ã§å°‘ã—ã®æ›´æ–°ã§ã‚‚å¤šãã®diskã¸ã®writeãŒãŠãã‚‹ ã‚«ãƒ©ãƒ ã‚’ä¸€ã¤æ›´æ–°ã—ãŸã ã‘ã§å¤šãã®indexã®æ›¸ãæ›ãˆãŒèµ·ã“ã‚‹ ã‚ˆã£ã¦ã€replicationã¯WALã‚’é€ã‚‹ã®ã§æ›´æ–°ãŒå¤šã„ã¨WALãŒå¤§é‡ã«é€ã‚‰ã‚Œã‚‹ repcliationã§ã¯ç‰©ç†çš„ãªdiskã®å¤‰æ›´ã‚’é€ã‚‹ DCé–“ã§ãƒ¬ãƒ—ãƒªã™ã‚‹ã¨ãã¤ã„ bugãŒã‚ã£ã¦replicaé–“ã§MVCCã®ä¸æ•´åˆãŒèµ·ãã‚‹ masterã¨replicaåŒã˜diskä¸Šã®ãƒ‡ãƒ¼ã‚¿æ§‹æˆã‚’å…±æœ‰ã™ã‚‹ã®ã§upgradeãŒã¤ã‚‰ã„ cache readã¯syscallã¨osã®page cacheçµŒç”±ãªã®ã§é‡ã„ 1ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³1ãƒ—ãƒã‚»ã‚¹
jitsu102 2016/10/18
uber

mysql

postgresql
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŠ€è¡“ã®ç¾…é‡ç›¤
Mesonã§PostgreSQLã‚’ãƒ“ãƒ«ãƒ‰ã—ã¦ã¿ã‚ˆã†ï¼ï¼ˆç¬¬39å›žPostgreSQLã‚¢ãƒ³ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹@ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ ç™ºè¡¨è³‡æ–™ï¼‰
jitsu102 2014/03/08
database

mysql

oracle

postgresql

engineer
ãƒªãƒ³ã‚¯
PostgreSQL Studio
Web-based PostgreSQL Development All you need is a modern web browser, from there you can simplify your PostgreSQL Development, run SQL queries, and manage your database. Continue Reading Open Source Web Interface for PostgreSQL PostgreSQL Studio makes it possible to edit your database code, navigate your schema and run full SQL queries from web pages that live in a browser. It is a database devel
jitsu102 2013/10/13
postgresql

tool
ãƒªãƒ³ã‚¯
1