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

ihok id:ihok

SQLã¨postgresqlã«é–¢ã™ã‚‹ihokã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

${{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: ã€ŒORã€ã‚’é¿ã‘ã¦ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å‘ä¸Šã•ã›ã‚ˆã†ï¼ˆç¿»è¨³ï¼‰ï½œTechRacho by BPSæ ªå¼ä¼šç¤¾
æ¦‚è¦ åŽŸè‘—è€…ã®è¨±è«¾ã‚’å¾—ã¦ç¿»è¨³ãƒ»å…¬é–‹ã„ãŸã—ã¾ã™ã€‚ è‹±èªžè¨˜äº‹: avoid OR for better PostgreSQL query performance - Cybertec åŽŸæ–‡å…¬é–‹æ—¥: 2018/05/07 è‘—è€…: Laurenz Albe ã‚µã‚¤ãƒˆ: CYBERTEC -- ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ã‚¹åˆ†é‡Žã§ã®PostgreSQLã‚µãƒãƒ¼ãƒˆã‚„ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ã‚’è¡Œã£ã¦ã„ã‚‹ä¼æ¥ã§ã™ â€»æŒ¿çµµã¯åŽŸè‘—è€…è‡ªã‚‰ã«ã‚ˆã‚‹ã‚‚ã®ã§ã™ã€‚ ç”Ÿãã‚‹ã¹ãã‹ã€ŽORã€æ»ã™ã¹ãã‹ã€ãã‚ŒãŒå•é¡Œã ã€ ã€Œå¸°ã‚Œï¼ã€ã€ŒéžåŠ¹çŽ‡ï¼ã€ã€ŒåŒç¾©åå¾©ï¼ã€ Â© Laurenz Albe 2018PostgreSQLã‚¯ã‚¨ãƒªã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¯ç§ãŸã¡Cybertecã®æ—¥å¸¸çš„ãªæ¥å‹™ã§ã™ãŒã€ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ä¸ã«ã‚¯ã‚¨ãƒªã«ORã‚’1ã¤ã§ã‚‚è¦‹ã¤ã‘ãŸçž¬é–“ã€æã‚ã—ã•ã«èº«ã®æ¯›ã‚‚ã‚ˆã ã¤æ€ã„ãŒã—ã¾ã™ã€‚ãŸã„ã¦ã„ã®å ´åˆã€ORã¯ã‚¯ã‚¨ãƒªã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ä½Žä¸‹ã®åŽŸå› ã¨ãªã‚‹ã‹ã‚‰ã§ã™ã€‚ è¨€ã†ã¾ã§ã‚‚ãªã„ã“
ihok 2020/04/16
ä¼šç¤¾

ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

ç¿»è¨³

ID

techracho

PostgreSQL

sql
ãƒªãƒ³ã‚¯
ã¨ã‚ã‚‹ã‚¯ã‚¨ãƒªã‚’2ä¸‡å€é€Ÿã«ã—ãŸè©± -ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ°—æŒã¡ã«ãªã‚‹- å‰ç·¨ - dwango on GitHub
æŠ€è¡“ã‚³ãƒŸãƒ¥ãƒ‹ã‚±ãƒ¼ã‚·ãƒ§ãƒ³å®¤ OSSã‚°ãƒ«ãƒ¼ãƒ—ã®é«™ï¨‘ã§ã™ã€‚ å½“ã‚°ãƒ«ãƒ¼ãƒ—ã§ã¯ã€ãƒžã‚¹ãƒˆãƒ‰ãƒ³ã¨ã„ã†ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®åˆ†æ•£åž‹ãƒžã‚¤ã‚¯ãƒãƒ–ãƒã‚°ã«ã¤ã„ã¦ã€ å¼Šç¤¾ãŒé‹å–¶ã™ã‚‹ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã€Œfriends.nicoã€ã®é‹å–¶ã€ç‹¬è‡ªæ©Ÿèƒ½ã®é–‹ç™ºã€é‹ç”¨ã€ãªã‚‰ã³ã«ãã‚Œã‚‰ã§å¾—ãŸçŸ¥è¦‹ã‚’ä¸Šæµã®ãƒ—ãƒ¬ãƒ¼ãƒ³ãªãƒžã‚¹ãƒˆãƒ‰ãƒ³ã¸contributeã™ã‚‹ã¨ã„ã†æ¥å‹™ã‚’ä¸»ã«è¡Œã£ã¦ã„ã¾ã™ã€‚ æœ¬è¨˜äº‹ã§ã¯ã€tableã«é©åˆ‡ãªindexã‚’å¼µã‚‹ã“ã¨ã«ã‚ˆã£ã¦ã¨ã‚ã‚‹ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªã®é€Ÿåº¦æ”¹å–„ã‚’è¡Œã£ãŸäº‹ä¾‹ã«ã¤ã„ã¦ã€å®Ÿéš›ã«ä¸Šæµã¸è¡Œã£ãŸPullRequestã‚’ãƒ™ãƒ¼ã‚¹ã«ãŠè©±ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚ å†…å®¹ã¨ã—ã¦ã¯åé¢æ•™å¸«ã¨ã™ã‚‹ã¹ãå¤±æ•—ä¾‹ã‚’ä¼´ã£ãŸã€éžå¸¸ã«åŸºç¤Žçš„ãªPostgreSQLã®å®Ÿè¡Œè¨ˆç”»ã®èªã¿æ–¹ãªã‚‰ã³ã«ã‚¯ã‚¨ãƒªã«åˆã‚ã›ãŸindexã®å¼µã‚Šæ–¹ã§ã™ã€‚ ã¾ãŸã€è¡¨é¡Œã®2ä¸‡å€é€Ÿã¨ã„ã†ã®ã¯æ”¹å–„å‰ã®æœ€æ‚ªã®å ´åˆæ¯”ã§ã‚ã‚Šå˜˜ã§ã¯ãªã„ã‚‚ã®ã®ã€é€šå¸¸å•ã„åˆã‚ã›ã•ã‚Œã‚‹ç¯„å›²ã®æ¡ä»¶ã§ã¯ã ã„ãŸã„3ã€œ30å€é€Ÿã§ã‚ã‚‹ã¨ã„ã†
ihok 2018/01/19
dwango

api

DB

postgresql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

mastodon

ã‚¯ã‚¨ãƒª

Rails

sql
ãƒªãƒ³ã‚¯
MySQL ã®ã‚µãƒ–ã‚¯ã‚¨ãƒªã£ã¦ã€ã»ã‚“ã¨ã«é…ã„ã®ï¼Ÿ | DevelopersIO
ã“ã‚“ã«ã¡ã¯ã€ã¿ã‹ã¿ã§ã™ã€‚ ä»Šæ—¥ã®ã‚¯ãƒ©ã‚¹ãƒ¡ã‚½ãƒƒãƒ‰ã®AWSãŠã¿ãã˜ã€RDSï¼ˆt1.microï¼‰ã§ã—ãŸãƒ¼ï¼ï¼ˆæ˜¨æ—¥ã¯ Auroraï¼ï¼ ï¼ ï½– ã¯ã˜ã‚ã« å‰è·ï¼ ã‚¢ãƒ—ãƒªé–‹ç™ºæ™‚ã€MySQL ã®ã‚¯ã‚¨ãƒªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ã•ã›ã¦ã„ãŸã ãæ©Ÿä¼šãŒã‚ã‚Šã¾ã—ãŸã€‚ ãƒ¦ãƒ¼ã‚¶ãƒ¼å…¥åŠ›ã®ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã§å…¨æ–‡æ¤œç´¢ â†’ è¦‹ã¤ã‹ã£ãŸãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’è¿”ã™ã®ã§ã™ãŒã€æ‰€è¦æ™‚é–“ã€ç´„3åˆ†ã€‚ã€‚ Apache ã‚¿ã‚¤ãƒ ã‚¢ã‚¦ãƒˆã—ã¦ç”»é¢çœŸã£ç™½ã€‚ã€‚ã€‚ï¼ˆæ³£ããã†ã§ã—ãŸï¼žï¼œã€‚ EXPLAINã§å®Ÿè¡Œè¨ˆç”»ã‚’èª¿ã¹ãŸéš›ã«ã€select_typeã«ã¯ã‚¯ã‚¨ãƒªã®ç¨®é¡žãŒè¡¨ç¤ºã•ã‚Œã‚‹ã®ã ãŒã€ä»£è¡¨çš„ãªã‚µãƒ–ã‚¯ã‚¨ãƒªã«ã¯æ¬¡ã®3ã¤ã®ãƒ‘ã‚¿ãƒ¼ãƒ³ãŒã‚ã‚‹ã€‚ SUBQUERY DEPENDENT SUBQUERY DERIVED çµè«–ã‹ã‚‰è¨€ãŠã†ã€‚é…ã„ã®ã¯2ç•ªç›®ã€DEPENDENT SUBQUERYã§ã‚ã‚‹ã€‚DEPENDENT SUBQUERYã¨ã¯ã„ã‚ã‚†ã‚‹ç›¸é–¢ã‚µãƒ–ã‚¯ã‚¨ãƒªã«ç›¸å½“ã™ã‚‹ã‚‚ã®ã§ã€ã‚µãƒ–ã‚¯ã‚¨ãƒªã«ãŠã„ã¦å¤–éƒ¨ã‚¯ã‚¨ãƒªã®
ihok 2017/06/04
DB

Aurora

Developers

apache

mysql

postgresql

sql

programming

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ããƒ¼ã ã„ãªã‚‹ã‚‰ããŒãå¸³: 2å¤§OSSãƒ†ã‚™ãƒ¼ã‚¿ãƒ˜ã‚™ãƒ¼ã‚¹ã®MySQLã¨PostgreSQLã®é•ã„ã«ã¤ã„ã¦è©±ã—ã¦ããŸ
ç¬¬32å›ž PostgreSQL å‹‰å¼·ä¼š(2015å¹´10æœˆ10æ—¥)ã§ç™»å£‡ã—ã¦ãã¾ã—ãŸã€‚ å†…å®¹ã¯å‰ã«æ›¸ã„ãŸã‚¨ãƒ³ãƒˆãƒªãƒ¼ã® MySQLä½¿ã„ãŒçŸ¥ã‚‹ã¹ãPostgreSQLã¨ã®é•ã„ã¨å¤‰ã‚ã‚‰ãªã„ä¸€ã¤ã®ã“ã¨ MySQLä½¿ã„ã®äººãŒPostgreSQLã‚’å§‹ã‚ã‚‹ã¨ãã®ç½ ã‚’ã¾ã¨ã‚ã¦ã¿ãŸ ã‚’å…ƒã«ç™ºè¡¨ã—ã¦ãã¾ã—ãŸã€‚ ã¨è¨€ã£ã¦ã‚‚ä»Šå›žã¯å‚åŠ è€…ãŒPostgresSQLã«è©³ã—ã„å‰æã ã£ãŸã®ã§MySQLã‚’ä¸å¿ƒã«è©±ã‚’ã—ã¾ã—ãŸã€‚ å®Ÿéš›ã®è³‡æ–™ã¯ä¸‹è¨˜ã®ã¨ãŠã‚Šã§ã™ã€‚ å½“æ—¥ã¯ãƒ“ãƒ‡ã‚ªæ’®å½±ãŒã‚ã£ãŸã®ã§ãã®ã†ã¡å‹•ç”»ãŒä¸ŠãŒã‚‹ã¨æ€ã„ã¾ã™ã€‚ ç¬¬32å›ž PostgreSQL å‹‰å¼·ä¼šã¾ã¨ã‚ ~ togetter ~ æµçŸ³ã«ï¼’æ™‚é–“ã¯ç–²ã‚Œã¾ã—ãŸã€‚ å†…å®¹ã¨ã—ã¦ã¯çœ ããªã‚‰ãªã„ã‚ˆã†ã«é¢ç™½ãŠã‹ã—ãä¼ãˆã‚ˆã†ã¨æ€ã£ãŸã®ã§ã™ãŒãªã‹ãªã‹é›£ã—ã‹ã£ãŸã§ã™ã€‚ å‰åŠã¯MySQLã¨PostgreSQLã®æ–¹å‘æ€§ã®é•ã„ã‚’ãƒ¡ã‚¤ãƒ³ã«ã—ã¾ã—ãŸã€‚ å¾ŒåŠã¯MySQLã¯åƒ•ãŒå®Ÿéš›ã«ãƒãƒžã£ãŸäº‹ãªã©ã‚’ãƒ¡ã‚¤
ihok 2015/10/13
postgresql

mysql

slide

db

SQL

oss

database

ãƒ›ãƒƒãƒˆã‚¨ãƒ³ãƒˆãƒª

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
DBã®Viewã‚’ä½œã£ãŸã‚‰Railsãƒ—ãƒã‚°ãƒ©ãƒ ãŒç¶ºéº—ã«ãªã£ãŸè©± | è‡ªè»¢è»Šã§é€šå‹¤ã—ã¾ã—ã‚‡â™ªãƒ–ãƒã‚°
æœ€è¿‘ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã„ã†ã‹SQLã«ã¤ã„ã¦å‹‰å¼·ã—ã¦ã„ã‚‹ã‚“ã§ã™ãŒã€å¥¥ãŒæ·±ã„ã§ã™ãã€‚ã“ã®å‰ã®ç¬¬9å›žä¸å›½åœ°æ–¹DBå‹‰å¼·ä¼šã®ã¨ãã«èžã„ãŸranké–¢æ•°ã‚’ä½¿ã£ã¦ã€ãƒ©ãƒ³ã‚ãƒ³ã‚°æ©Ÿèƒ½ã‚’ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã—ã‚ˆã†ï¼ã¨æ€ã£ã¦æœ€è¿‘é ‘å¼µã£ã¦ã¾ã™ã€‚ã¨ã„ã†ã®ã‚‚ã€è¤‡é›‘ãªã‚¯ã‚¨ãƒªï¼ˆé…ã„ï¼‰ã‚’æ¥ç¨®æ•°åˆ†ï¼ˆ10å›žãã‚‰ã„ï¼‰å‘¼ã‚“ã§ã„ãŸãŸã‚ã€Herokuã ã¨çµæ§‹ã‚®ãƒªã‚®ãƒªã®é€Ÿåº¦ã«ãªã‚‹ã“ã¨ã‚‚ã‚ã£ãŸã®ã§ã€ãªã‚“ã¨ã‹ã—ãªã‘ã‚Œã°ï¼ã¨æ€ã£ã¦ã„ãŸã®ã§ã™ã€‚ ã¨ã‚Šã‚ãˆãšã€ç§ã®é–‹ç™ºç’°å¢ƒã‚’è¼‰ã›ã¦ãŠãã¾ã™ã€‚ Mac Yosem ite Ruby 2.2 Rails 4.2.1 PostgreSQL 9.3.4 ã²ã¨ã¾ãšranké–¢æ•°ã‚’ä½¿ã†ã¨ã“ã‚ã¾ã§ ã¾ãšã€NewRelicã‚’ä½¿ã£ã¦ActiveRecordãŒå‡ºåŠ›ã—ã¦ã„ã‚‹SQLã‚’å–å¾—ã—ã€ãã‚Œã‚’0xDBEã®ã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã«è²¼ã‚Šä»˜ã‘ã¦ã€ranké–¢æ•°ã‚’ä½¿ã£ã¦æ¥ç¨®ã§ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã—ã¦ãƒ©ãƒ³ã‚ãƒ³ã‚°ã‚’å‡ºã™ã¨ã“ã‚ã¾ã§ã—ã¦ã¿ã¾ã—ãŸã€‚ranké–¢æ•°ã¯ã€é–¢æ•°å
ihok 2015/09/18
DB

activerecord

sql

ID

slide

Ruby on Rails

postgresql

database

Rails
ãƒªãƒ³ã‚¯
DBã®è‡ªå‹•é€£ç•ªãŒãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ã—ã¦ã‚‚æˆ»ã‚‰ãªã„ç†ç”± - C Sharpens you up
DBã®ä¸»ã‚ãƒ¼ã‚«ãƒ©ãƒ ã«è‡ªå‹•é€£ç•ªï¼ˆMySQLãªã‚‰AUTO_INCREMENTã€SQL Serverãªã‚‰IDENTITYã€Oracleã‚„PostgreSQLãªã‚‰ã‚·ãƒ¼ã‚±ãƒ³ã‚¹ï¼‰ã‚’è¨å®šã—ã¦ã„ã‚‹ã¨ã€åŸºæœ¬çš„ã«ã¯é€£ç¶šã—ãŸæ•°å—ãŒä»˜ç•ªã•ã‚Œã¦ã„ãã®ã§ã™ãŒã€è¡Œå‰Šé™¤ã‚‚ã—ã¦ã„ãªã„ã®ã«æŠœã‘ç•ªãŒç™ºç”Ÿã™ã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ INSERTãŒåˆ¶ç´„ã«ã²ã£ã‹ã‹ã£ã¦å¤±æ•—ã—ãŸ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ã—ãŸ ãªã©ã®å ´åˆã§ã™ã€‚ ç‰¹ã«ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ã¯ã€DBå…¨ä½“ã®å¤‰æ›´ã‚’ãªã‹ã£ãŸã“ã¨ã«ã™ã‚‹ã¯ãšãªã®ã«é€£ç•ªã ã‘ã¯é€²ã‚“ã ã¾ã¾æˆ»ã‚‰ãªã„ã¨ã„ã†ã“ã¨ã§ã€çŸ¥ã‚‰ãªã„ã¨é•å’Œæ„ŸãŒã‚ã‚‹ã‚‚ã®ã§ã™ã€‚ é€£ç•ªãŒæˆ»ã‚‰ãªã„ç†ç”± PostgreSQLã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãŒã“ã†èª¬æ˜Žã—ã¦ã„ã¾ã™ã€‚ åŒä¸€ã®ã‚·ãƒ¼ã‚±ãƒ³ã‚¹ã‹ã‚‰æ•°å€¤ã‚’å–å¾—ã™ã‚‹åŒæ™‚å®Ÿè¡Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åŒå£«ã®ãƒ–ãƒãƒƒã‚¯ã‚’é˜²æ¢ã™ã‚‹ãŸã‚ã€nextvalæ¼”ç®—ã¯æ±ºã—ã¦ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ã•ã‚Œã¾ã›ã‚“ã€‚ http://www.postgresq
ihok 2015/06/01
DB

postgresql

RDB

sql

RDBMS

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯

ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³

é€£ç•ª
ãƒªãƒ³ã‚¯
1