postgres.new: In-browser Postgres with an AI interface
Introducing postgres.new, the in-browser Postgres sandbox with AI assistance. With postgres.new, you can instantly spin up an unlimited number of Postgres databases that run directly in your browser (and soon, deploy them to S3). Each database is paired with a large language model (LLM) which opens the door to some interesting use cases: Drag-and-drop CSV import (generate table on the fly) Generat
Exploring Notion's Data Model: A Block-Based Architecture | Notion
A generation of pioneers (Doug Engelbart, Ted Nelson, Alan Kay, and many more) saw the computer as tool to augment human problem-solving by giving people power over information. Today, that information mostly remains siloed across tools. Take cloud-based document editors, where pages are their smallest atomic unit. Information is locked inside of pages and files and folders — that’s reminiscent of
PostgreSQLã®æ©Ÿèƒ½ã¨ä»–ã®RDBMSã®æ¯”較 | Let's POSTGRES
å…¨ã¦ã®æ©Ÿèƒ½ã‚’網羅ã—ãŸè¡¨ã§ã¯ã‚ã‚Šã¾ã›ã‚“ãŒã€PostgreSQL㌠Oracle Database ã¨åŒæ§˜ã®æ©Ÿèƒ½ãŒã‚ã‚‹ã“ã¨ãŒãŠåˆ†ã‹ã‚Šã„ãŸã ã‘ã‚‹ã§ã—ょã†ã€‚レプリケーションやクラスタリングãªã©ã¯ã€PostgreSQL本体ã¨ã¯åˆ¥ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã‚‹ã‚µãƒ¼ãƒ‰ãƒ‘ーティーã§ã®æä¾›ã¨ãªã‚Šã¾ã™ãŒã€pgpool-II, Slony-I ã‚’ã¯ã˜ã‚ã¨ã—ãŸå®Ÿç¸¾ã‚‚豊富ãªã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ãŒæä¾›ã•ã‚Œã¦ã„ã¾ã™ã€‚ PostgreSQLãŒç‰¹ã«å¼·ã¿ã‚’発æ®ã™ã‚‹åˆ†é‡Žã¨ã—ã¦ã€æœ€å¾Œã®è¡Œã«è¨˜è¼‰ã—ãŸGIS (地ç†æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ ) ãŒã‚ã‚Šã¾ã™ã€‚GISã¯ä½ç½®ã«é–¢ã™ã‚‹æƒ…å ±ã‚’æŒã£ãŸãƒ‡ãƒ¼ã‚¿ (空間データ) を管ç†ã—ã€ä¸»ã«åœ°å›³ã¨çµ„ã¿åˆã‚ã›ã¦ä½ç½®ã‚’表示ã€æ¤œç´¢ã€åˆ†æžã™ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã§ã™ã€‚PostgreSQLã§ã¯ã€PostGIS ã¨ã„ã†ã‚µãƒ¼ãƒ‰ãƒ‘ーティーソフトウェアã§ã€GISオブジェクトをデータベースã«æ ¼ç´ã—空間データã«é©ã—ãŸæ¤œç´¢ã‚’è¡Œã†ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã€GISオブジェクトを解æžã™
PostgreSQL ã«ãŠã‘ã‚‹ Index Scan 㨠Bitmap Scan - higepon blog
PostgreSQL ã® Planner ㌠Index Scan よりも Bitmap Scan を好むç†ç”±ãŒã‚„ã£ã¨åˆ†ã‹ã£ãŸã€‚（Tom Lane ã•ã‚“ã«æ•™ãˆã¦ã‚‚らã£ãŸï¼‰ã€‚ Bitmap Scan ãŒæœ‰åˆ©ãªã‚¯ã‚¨ãƒªãƒ¼ã¯ã¨ã‚‚ã‹ã select * from emp where emp_no > 10000; ã®ã‚ˆã†ãªå˜ç´”ãªã‚¯ã‚¨ãƒªãƒ¼ã§ã‚‚ã€Bitmap Scan ãŒé¸ã°ã‚Œã‚‹ã®ãŒåˆ†ã‹ã‚‰ãªã‹ã£ãŸã€‚ Bitmap を作ã£ãŸã‚ã¨ã«ç‰¹ã« bit 演算ã›ãšã€ãã®ã¾ã¾ tuple ã‚’å–得。 一見ã™ã‚‹ã¨ã»ã¨ã‚“ã© Index Scan ã¨é€Ÿåº¦ãŒå¤‰ã‚らãªã„よã†ã«è¦‹ãˆã‚‹ã—ã€ã‚€ã—ã‚ Bitmap を作るã ã‘æã ã¨ã‚‚æ€ãˆã‚‹ã€‚ ã§ã‚‚実㯠Bitmap Scan ã§ã¯ tuple を引ãã¨ãã«æœ€é©ãªæ–¹æ³•ã§ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã™ã‚‹ã®ã ãã†ã 。 例ãˆã° Bitmap を利用ã—ã¦åŒã˜ãƒšãƒ¼ã‚¸ã¯1度ã—ã‹èªã¾ãªã„ã¨ã‹ã€‚ Index Scan ã§ã¯
1
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
{{#tags}}- {{label}}
{{/tags}}