El Capitan ã« PostgreSQL をインストールã™ã‚‹
$ brew install postgres Warning: You are using OS X 10.11. We do not provide support for this pre-release version. You may encounter build failures or other breakage. ==> Downloading https://homebrew.bintray.com/bottles/postgresql-9.4.4.el_capitan Already downloaded: /Library/Caches/Homebrew/postgresql-9.4.4.el_capitan.bottle.tar.gz ==> Pouring postgresql-9.4.4.el_capitan.bottle.tar.gz ==> Caveats
PG-Strom - Limit Breaker of PostgreSQL powered by GPU
PG-Strom Overview PG-Stromæ¦‚è¦ This chapter introduces a brief overview of PG-Strom and developer community. æœ¬ç« ã§ã¯ã€PG-Stromã®æ¦‚è¦ã€ãŠã‚ˆã³é–‹ç™ºè€…コミュニティã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ What is PG-Strom PG-Stromã¨ã¯ï¼Ÿ PG-Strom is an extension designed for PostgreSQL v9.5 or later, to off-load a part of CPU intensive workloads to GPU (Graphic Processor Unit) devices, and execute them in parallel asynchronously. This module is designed to r
KaiGaiã®ä¿ºãƒ¡ãƒ¢
今回ã¯çš†ã•ã‚“ãŒå¤§å¥½ããªä¾¿åˆ©ãƒ„ール「pg2arrowã€ã®ãŠè©±ã§ã™ã€‚ PostgreSQLã§ãƒãƒ¼ã‚¿ãƒ–ルãªåˆ—指å‘ãƒ‡ãƒ¼ã‚¿å½¢å¼ Apache Arrow ã‚’èªã¿å‡ºã™ã«ã¯ã€Arrow_Fdwを利用ã™ã‚‹äº‹ãŒã§ãã¾ã™ã€‚ PG-Stromã§ã¯GPU-Direct SQLã«ã‚‚対応ã—ã¦ã„ã¾ã™ã—ã€åˆ—指å‘データã¨ã„ã†äº‹ã‚‚ã‚ã£ã¦ã€è¢«å‚照列ã—ã‹I/OãŒç™ºç”Ÿã—ãªã„ã€åŒã˜åˆ—ã®ãƒ‡ãƒ¼ã‚¿ãŒè¿‘å‚ã«å›ºã¾ã£ã¦ã„ã‚‹ã¨ã„ã†å¤§é‡ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã«é©ã—ãŸç‰¹æ€§ã‚’æŒã£ã¦ã‚‚ã„ã¾ã™ã€‚ ã¾ãŸã€Apache Arrowå½¢å¼ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’作æˆã™ã‚‹ã«ã¯PyArrowã‚„Pandasãªã©æ§˜ã€…ãªãƒ„ールãŒã‚ã‚Šã¾ã™ãŒã€æˆ‘々DB屋ã¨ã—ã¦ã¯PostgreSQLã«æ ¼ç´ã•ã‚ŒãŸãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒŠãƒ«ãªãƒ‡ãƒ¼ã‚¿ã‚’ã€åˆ†æžç”¨ã«Apache Arrowå½¢å¼ã¨ã—ã¦åã出ã›ã‚‹ã¨ã¨ã¦ã‚‚嬉ã—ã„。ãã‚“ãªæ™‚ã«ä½¿ãˆã‚‹ãƒ„ールãŒpg2arrowãªã®ã§ã™ã€‚ pg2arrowã¯ã€PostgreSQLã«ã‚¯ã‚¨ãƒªã‚’投ã’ã€ãã®å•
ã€PostgreSQL】レコードãŒå˜åœ¨ã™ã‚Œã°UPDATEã€ãªã‘ã‚Œã°INSERTã‚’SQLæ–‡ã§å®Ÿç¾ã™ã‚‹
(2017/07/25追記) 1クエリã§å®Ÿç¾ã™ã‚‹æ–¹æ³•ã‚’書ãã¾ã—ãŸã€‚ ã€PostgreSQL】レコードãŒå˜åœ¨ã™ã‚Œã°UPDATEã€ãªã‘ã‚Œã°INSERTã‚’1クエリã§å®Ÿç¾ã™ã‚‹ ã„ã¡ã„ã¡SELECTã—ã¦ãã¦ã€ã¨ã£ã¦ããŸå€¤ã‚’検証ã—ã¦SQL文を生æˆã—ãªãŠã—ã¦ã€ ã“ã‚Œã˜ã‚ƒé¢å€’ãªã®ã§ã€SQLæ–‡ã ã‘ã§ãªã‚“ã¨ã‹ãªã‚‰ãªã„ã‹èª¿ã¹ã‚‹ã“ã¨ã«ã€‚ å‚考 http://stackoverflow.com/questions/11135501/postgresql-update-if-row-with-some-unique-value-exists-else-insert 英語ã¯ã‚ã¾ã‚Šåˆ†ã‹ã‚‰ãªã„ã§ã™ãŒã€ã‚³ãƒ¼ãƒ‰ã‹ã‚‰èªã¿è§£ã。 UPDATE table SET field='C', field2='Z' WHERE id=3; INSERT INTO table (id, field, field2) SELECT 3, 'C'
1
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
{{#tags}}- {{label}}
{{/tags}}