![[B23] PostgreSQLΥǥå?`˥ by Tomonari Katsumata](https://cdn.slidesharecdn.com/ss_thumbnails/b23ntt-140624233630-phpapp02-thumbnail.jpg?width=560&fit=bounds)
![[db tech showcase Tokyo 2015] B15:PostgreSQLϥѥե`ޥwSĤϤ룡 - PostgreSQ...](https://cdn.slidesharecdn.com/ss_thumbnails/dbts-tokyo-2015b15postgresqlntt-oss-center-150619073139-lva1-app6891-thumbnail.jpg?width=560&fit=bounds)
More Related Content
What's hot (20)
Similar to 10˥`귵ʳҰDz2015 (20)
![[db tech showcase Tokyo 2018]#dbts2018 #E37 Attunity Replicate䤨 Oracle D...](https://cdn.slidesharecdn.com/ss_thumbnails/dbts2018e37ctc-181004235303-thumbnail.jpg?width=560&fit=bounds)
More from NTT DATA OSS Professional Services (20)
Recently uploaded (11)
10˥`귵ʳҰDz2015
- 1. Copyright ? 2015 NTT DATA Corporation 2015627 ()NTTǩ` 10˥`귵ʳҰDz2015 @JPUG 2015 ĥߥ
- 2. 2Copyright ? 2015 NTT DATA Corporation PostgreSQL Хꥹ@ NTT ǩ` PostgreSQL ӘI?g֧Ԯ GresCube _k?ݩ` PostgreSQL ߥå ȫ20ձˤ3Ŀ PostgreSQL ΥCܤ_k ץꥱ`(ͬ / ͬ / `) ȥRs pg_bigm(ȫė⥸`) پ @fujii_masao
- 3. Copyright ? 2015 NTT DATA Corporation 3 PGConȤ
- 4. 4Copyright ? 2015 NTT DATA Corporation PGConȤ PostgreSQLvΥե ճ 2015/6/16() 6/20() ѧ μ 244 TalksTutorialsUnconference3 ؏ ФPostgreSQL_k?`ϣ PostgreSQLˤĤƤҤZĤ ʽ http://www.pgcon.org/2015/ ϥå奿 #pgcon
- 5. 5Copyright ? 2015 NTT DATA Corporation PGConؤεΤ DATE/TIME CITY/AIRPORT FLIGHT FLTTIME --------------------------------------------------------------------- 6/15 () 17:40 |/ AC0006 12:00 16:40 ȥ AIR CANADA ---------------------------------------------------------------------- 19:10 ȥ AC0464 01:03 20:13 AIR CANADA ---------------------------------------------------------------------- ƄӤ16rgr13rg
- 6. 6Copyright ? 2015 NTT DATA Corporation ` DAY Track1 Track2 Track3 Track4 Other 6/16 (Tue) PM AM 17 (Wed) PM AM 18 (Thu) PM AM 19 (Fri) PM AM 20 (Sat) PM AM Unconference Talks Tutorial Developer Meeting Major Social Event! Registration Pickup Tutorial TalksTutorialUnconference3
- 7. 7Copyright ? 2015 NTT DATA Corporation μM Type Talks Tutorial Unconference $195 $75 (per half day) $0 (һĿ) $350 (ĿԽ) $200 ѧ $60 ֧Bϥʥɥ CAD$1 = 100.42 (6/12r)
- 8. Copyright ? 2015 NTT DATA Corporation 8 10λ Developer Meeting _ߣ
- 9. 9Copyright ? 2015 NTT DATA Corporation Developer MeetingȤ PostgreSQLΥ_kߤΤߤдh Photo by Oleg Bartunov https://www.flickr.com/photos/obartunov/18245690144
- 10. 10Copyright ? 2015 NTT DATA Corporation Developer MeetingȤ ϼgΥȥԥåhՓ Developer Meeting Developer Meeting Developer Unconference ߥ˥ƥ\ _k` gȥԥå ߥ˥ƥ\ _k` gȥԥå 2015 2014
- 11. 11Copyright ? 2015 NTT DATA Corporation Developer MeetinghՓ줿 hhϤ٤Wiki˒d https://wiki.postgresql.org/wiki/PgCon_2015_Developer_Meeting PGCon2015 Developer Meeting
- 12. 12Copyright ? 2015 NTT DATA Corporation Developer MeetinghՓ줿 r _k٥ 2015 7 CommitFest 1 9 CommitFest 2 11 CommitFest 3 2016 1 CommitFest 4 3 CommitFest 5 4 Feature Freeze 6 ¥Щ`` 10 PostgreSQL 9.6 ` PostgreSQL 9.6 _k`뤬Q
- 13. 13Copyright ? 2015 NTT DATA Corporation Developer MeetinghՓ줿 ߥ˥ƥҪQ˥ߥåμӤǤ褦 ` _k ` Mailing List Х桢_khՓʥ ߥå `ȥӥ` ѥå ṩ x PostgreSQLߥ˥ƥ\ΑB Wiki TODO_kMù GitHub ``ɹ Х Ҫ x `Ήޤ_k ʮΤ ¥Щ`?`vhՓ ҎߥåxvhՓ
- 14. Copyright ? 2015 NTT DATA Corporation 14 9λ Developer Unconference _ߣ
- 15. 15Copyright ? 2015 NTT DATA Corporation Developer UnconferenceȤ PostgreSQLμgĤʹ_ӑՓ Photo by Oleg Bartunov https://www.flickr.com/photos/obartunov/18718087759
- 16. 16Copyright ? 2015 NTT DATA Corporation Developer UnconferenceȤ ʼgͥˤĤƹ_ӑՓ Developer Meeting Developer Meeting Developer Unconference ߥ˥ƥ\ _k` gȥԥå ߥ˥ƥ\ _k` gȥԥå 2015 2014
- 17. 17Copyright ? 2015 NTT DATA Corporation Developer UnconferencehՓ줿 hhϸŤWiki˒d https://wiki.postgresql.org/wiki/PgCon_2015_Developer_Unconference PGCon2015 Developer Unconference
- 18. 18Copyright ? 2015 NTT DATA Corporation Developer UnconferencehՓ줿 Autonomous Transaction PL/pgSQL vڤǥȥ_ʼȽKˤܤ PRAGMA AUTONOMOUS_TRANSACTION @ Oracle 2ndQuadrant Huawei 9.6 Ǥ_kӋ BEGIN; SELECT hoge(); COMMIT; BEGIN; INSERT ... ... COMMIT; BEGIN; UPDATE ... ... COMMIT;
- 19. 19Copyright ? 2015 NTT DATA Corporation Developer UnconferencehՓ줿 ܸ 1 A B C D 1 a B C D 1 A B C D a CREATE TABLE test (id INT, col1 TEXT, col2 TEXT, col3 TEXT, col4 TEXT); INSERT INTO test VALUES (1, 'A', 'B', 'C', 'D'); UPDATE test SET col1 = 'a' WHERE id = 1; F״ ư (ǤʤФ⺬)٤ƤФӛ ²֤Τߤӛ
- 20. Copyright ? 2015 NTT DATA Corporation 20 8λ `ʢr
- 21. 21Copyright ? 2015 NTT DATA Corporation ` CAD$40
- 22. 22Copyright ? 2015 NTT DATA Corporation ` CAD$60
- 23. 23Copyright ? 2015 NTT DATA Corporation ` CAD$150
- 24. 24Copyright ? 2015 NTT DATA Corporation ` CAD$400
- 25. 25Copyright ? 2015 NTT DATA Corporation Joe CelkoSQL guru
- 26. 26Copyright ? 2015 NTT DATA Corporation ` CAD$653
- 27. Copyright ? 2015 NTT DATA Corporation 27 7λ JSONB˚ݣ
- 28. 28Copyright ? 2015 NTT DATA Corporation JSONB Event Title Tutorial NoSQL on ACID Talk Update and Delete operations for jsonb Rethinking JSONB Unconference Direction of json and jsonb
- 29. 29Copyright ? 2015 NTT DATA Corporation PostgreSQLˤJSONΚsʷ v9.2 (2012) v9.3 (2013) v9.4 (2014) v9.5 TEXT + ĥå ÿܤv Ϥ鷺 4 Ҫس(->) v10 JSONФؤΉQ Хʥʽ + ĥå GINǥå JSON ݩ` JSONB ݩ` !? vӤ g
- 30. 30Copyright ? 2015 NTT DATA Corporation JSONB9.5CܤޤȤ v --# || jsonb_concat() jsonb_delete() jsonb_set() jsonb_pretty() JSONBͤҊ䤹 NEW! NEW! NEW! NEW! NEW! NEW!
- 31. Copyright ? 2015 NTT DATA Corporation 31 6λ JPUGvSߤˤvݤ^ȥ࣡
- 32. 32Copyright ? 2015 NTT DATA Corporation JPUGvSߤˤvݤ^ȥ - 11 Event Title Speaker Unconference Horizontal Scalability / Sharding in PostgreSQL Etsuro Fujita pgPool2 towards version 3.5 Tatsuo Ishii Partitioning Amit Langote Foreign Data Wrapper enhancements Shigeru Hanada Etsuro Fujita Utilization of modern semiconductors KaiGai Kohei Talk PostgreSQL on FPGA Satoshi Nagayasu Monitor more of PostgreSQL Kyotaro Horiguchi The Art of Performance Evaluation Yuto Hayamizu PG-Strom KaiGai Kohei Improving PostgreSQL for Greater Enterprise Adoption Tetsuo Sakata Yurie Enomoto Lightning Talk Postgres Toolkit & pgDay Asia 2016 Satoshi Nagayasu
- 33. Copyright ? 2015 NTT DATA Corporation 33 5λ CPUܥȥͥårȡMߤĤ
- 34. 34Copyright ? 2015 NTT DATA Corporation CPUܥȥͥårȡM CPUܥȥ ͥår Native Compilation H/W Offloading Memory size > DB size Flash storage GPU FPGA (Field Programmable Gate Arra) CPU¤p餹 CPU¤Τ PL/pgSQL C exe Q ?????? Generate specialized code + Compilation + Execute compiled code
- 35. Copyright ? 2015 NTT DATA Corporation 35 4λ Postgres-XC廯ӋšM!?
- 36. 36Copyright ? 2015 NTT DATA Corporation Postgres-XC廯Ӌ!? XCKзɢCܤPostgreSQL˽MzӋ PG PG PG PG Partitioning + FDW backend gƩ`֥ ⲿƩ`֥ Parallel Query worker worker worker worker Pushdown Automatic Foreign Tx SQL
- 37. 37Copyright ? 2015 NTT DATA Corporation Postgres-XC廯Ӌ!? 9.5 ⲿƩ`֥Υѩ`ƥMz JOIN pushdown 9.6 JOIN pushdownؤpostgres_fdwΌ ѩ`ƥ˥(ֱ?) ѥ륹 Automatic Foreign Transaction 9.7 ѥ륯 Sharding More and more pushdown (Sort, Aggregate, Update, ...)
- 38. Copyright ? 2015 NTT DATA Corporation 38 3λ pgDay Asia @ FOSSASIA 2016 ʼ!?
- 39. 39Copyright ? 2015 NTT DATA Corporation pgDay Asia @ FOSSASIA 2016 FOSSASIA March 18th - 20th in Singapore ǰؤϡ27顢128ˤΥԩ``900Ϥβμ FOSSASIAΥ祤ȥ٥ȤȤpgDay12ȥå_ߤǤʤ JPUGLӋ륢PostgreSQL٥
- 40. Copyright ? 2015 NTT DATA Corporation 40 2λ PostgreSQLgߡPGCondzL
- 41. 41Copyright ? 2015 NTT DATA Corporation PostgreSQLgߤγLӛh
- 42. 42Copyright ? 2015 NTT DATA Corporation PostgreSQLgߤγLӛh kǰ
- 43. 43Copyright ? 2015 NTT DATA Corporation PostgreSQLgߤγLӛh ո
- 44. 44Copyright ? 2015 NTT DATA Corporation PostgreSQLgߤγLӛh 1Ŀǰ Ω`ȥ}åХꥫ ȥꥪ`g^ ѩ`?ҥ
- 45. 45Copyright ? 2015 NTT DATA Corporation PostgreSQLgߤγLӛh Unconferenceֱ
- 46. 46Copyright ? 2015 NTT DATA Corporation PostgreSQLgߤγLӛh μgߤԒʼơ
- 47. 47Copyright ? 2015 NTT DATA Corporation PostgreSQLgߤγLӛh Lightning Talkֱ
- 48. 48Copyright ? 2015 NTT DATA Corporation PostgreSQLgߤγLӛh
- 49. 49Copyright ? 2015 NTT DATA Corporation Quorum CommitȤ ޥ Х С ХΤ2̨𤬤ä ͬڥץꥱ`ˤжϤ ͬڥץꥱ`ΤܛʘɤܤˤC
- 50. Copyright ? 2015 NTT DATA Corporation 50 1λ PostgreSQL9.5CܡB飡
- 51. 51Copyright ? 2015 NTT DATA Corporation 9.5Cܤ֪ꤿȤ `Ω` http://www.postgresql.org/docs/devel/static/release-9-5.html CܽB饹饤 @ PGCon2015 http://slides.keithf4.com/pg95live/#/ CܽB֥ http://michael.otacoo.com/ http://www.depesz.com/tag/postgresql/ ߥ˥ƥʽWikiϤӛ https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.5 9.5_kय ѥåɤ˼ ߥ뤵Υ֥
- 52. 52Copyright ? 2015 NTT DATA Corporation UPSERT INSERT INTO emp VALUES (3, 'ľ', '_k') ON CONFLICT (id) DO UPDATE SET name = EXCLUDE.name, role = EXCLUDE.role; ФʤINSERTUPDATEg id name role 1 _k 2 ӘI 3 ľ _k 4 ɽ U 5 ӘI id=3Фʤ INSERT INTO emp VALUES (3, 'ľ', '_k'); id=3Ф UPDATE emp SET name = 'ľ', role = '_k' WHERE id = 3;
- 53. 53Copyright ? 2015 NTT DATA Corporation ROW LEVEL SECURITY id name age role 1 27 _k 2 53 ӘI 3 ľ 45 _k 4 ɽ 39 U 5 31 ӘI `foo empƩ`֥ ) _kߤΤߤ`fooESɤ CREATE POLICY emp_foo_policy ON emp FOR SELECT TO foo USING (role = '_k'); `E?ǤФָǤC
- 54. 54Copyright ? 2015 NTT DATA Corporation pg_rewind եХårDBǩ`֥ХååܞͤǤC ץꥱ` ޥ Х ֹͣ ޥ ޥ Х ץꥱ` ֹͣ ޥ Хå å IϵڃP ޥgڃP IϵڃP ֥Хååܞ ޥϤˤ ե륪` ɥޥٽMz (եХå) pg_rewind եХårg̿s
- 55. Copyright ? 2015 NTT DATA Corporation 55
- 56. 56Copyright ? 2015 NTT DATA Corporation PGConʤμӤƤߤޤ 6
- 57. Copyright ? 2011 NTT DATA Corporation Copyright ? 2015 NTT DATA Corporation