Upgrade to Pro — share decks privately, control downloads, hide ads and more …

生誕20周年を迎えたPostgreSQLを使ってみよう

Avatar for soudai sone soudai sone
November 05, 2016

 生誕20周年を迎えたPostgreSQLを使ってみよう

Avatar for soudai sone

soudai sone

November 05, 2016
Tweet

More Decks by soudai sone

Other Decks in Technology

Transcript

  1. ܥ࣌୅    ෭໰߹ͤ 1-5DM  1-QH42- 7JFX 

    ϚϧνόΠτจࣈྻαϙʔτ  .7$$ Ұ࣌ද $"4&  */5&34&$5 &9$&15 ܥ࣌୅    ֎෦Ωʔ੍໿  8"- 50"45 065&3+0*/  ίϯΧϨϯτ7"$66.  1-1ZUIPO  εΩʔϚ υϝΠϯ 13&1"3&  *1W JOGPSNBUJPO@TDIFNB ܥ࣌୅    .JDSPTPGU8JOEPXTରԠ  4"7&10*/5 1*53 දྖҬ  ૬ίϛοτ 30-& ߦڞ༗ϩοΫ  ςʔϒϧɾύʔςΟγϣχϯά  ΢ΥʔϜελϯόΠ (*/  ߋ৽ॲཧੑೳͷ޲্ 9.-σʔλܕ  શจݕࡧ +*49  &/6.ܕ 66*%ܕ  ࠶ؼΫΤϦ ΢Οϯυ΢ؔ਺  ྻ୯ҐͷΞΫηε੍ޚ 42-ͱؔ਺ͷੑೳղੳػೳ
  2. ܥ࣌୅   ˞ͷ࣍͸ͰܾఆࡁΈ ܥ࣌୅ ݱࡏ   ϨϓϦέʔγϣϯ Ұׅݖݶมߋ

    ಗ໊ϓϩγʔδϟ CJU8JOEPXTαϙʔτ  Ҡಈฏۉ ྻ৚݅τϦΨ Ұҙੑ੍໿ͷ஗Ԇ ഉଞ੍໿  ಉظϨϓϦέʔγϣϯ ֎෦ςʔϒϧ ύοέʔδ؅ཧ 6/-0((&%ςʔϒϧ  ߋ৽Մೳͳ8*5)۟ ۙ๣ݕࡧ 4&-JOVYݖݶ੍ޚ  ΠϯσοΫεΦϯϦʔεΩϟϯ ΧεέʔυϨϓϦέʔγϣϯ +40/ܕ ൣғܕ  ϚςϦΞϥΠζυϏϡʔ ֎෦ςʔϒϧ΁ͷॻ͖ग़͠ ΠϕϯττϦΨ  σʔλϖʔδɾνΣοΫαϜ -"5&3"-۟  +40/#ܕ 42-͔Βͷαʔόʔઃఆͷมߋ ϨϓϦέʔγϣϯεϩοτ  614&35ػೳ ϒϩοΫϨϯδΠϯσοΫε ߦ୯ҐηΩϡϦςΟ੍ޚίϚϯυ  ύϥϨϧΫΤϦ ෳ਺ಉ࣌ελϯόΠ શจݕࡧͷϑϨʔζରԠ  $01:จͷSFUVSOJOH۟ରԠ
  3. ܥ࣌୅   ˞ͷ࣍͸ͰܾఆࡁΈ ܥ࣌୅ ݱࡏ   ϨϓϦέʔγϣϯ Ұׅݖݶมߋ

    ಗ໊ϓϩγʔδϟ CJU8JOEPXTαϙʔτ  Ҡಈฏۉ ྻ৚݅τϦΨ Ұҙੑ੍໿ͷ஗Ԇ ഉଞ੍໿  ಉظϨϓϦέʔγϣϯ ֎෦ςʔϒϧ ύοέʔδ؅ཧ 6/-0((&%ςʔϒϧ  ߋ৽Մೳͳ8*5)۟ ۙ๣ݕࡧ 4&-JOVYݖݶ੍ޚ  ΠϯσοΫεΦϯϦʔεΩϟϯ ΧεέʔυϨϓϦέʔγϣϯ +40/ܕ ൣғܕ  ϚςϦΞϥΠζυϏϡʔ ֎෦ςʔϒϧ΁ͷॻ͖ग़͠ ΠϕϯττϦΨ  σʔλϖʔδɾνΣοΫαϜ -"5&3"-۟  +40/#ܕ 42-͔Βͷαʔόʔઃఆͷมߋ ϨϓϦέʔγϣϯεϩοτ  614&35ػೳ ϒϩοΫϨϯδΠϯσοΫε ߦ୯ҐηΩϡϦςΟ੍ޚίϚϯυ  ύϥϨϧΫΤϦ ෳ਺ಉ࣌ελϯόΠ શจݕࡧͷϑϨʔζରԠ  $01:จͷSFUVSOJOH۟ରԠ ܥ͚ͩͰ΋ࡌ͖ͤΕͳ͍΄Ͳͷػೳ௥Ճ΍վળ
  4. ܥ࣌୅   ˞ͷ࣍͸ͰܾఆࡁΈ ܥ࣌୅ ݱࡏ   ϨϓϦέʔγϣϯ Ұׅݖݶมߋ

    ಗ໊ϓϩγʔδϟ CJU8JOEPXTαϙʔτ  Ҡಈฏۉ ྻ৚݅τϦΨ Ұҙੑ੍໿ͷ஗Ԇ ഉଞ੍໿  ಉظϨϓϦέʔγϣϯ ֎෦ςʔϒϧ ύοέʔδ؅ཧ 6/-0((&%ςʔϒϧ  ߋ৽Մೳͳ8*5)۟ ۙ๣ݕࡧ 4&-JOVYݖݶ੍ޚ  ΠϯσοΫεΦϯϦʔεΩϟϯ ΧεέʔυϨϓϦέʔγϣϯ +40/ܕ ൣғܕ  ϚςϦΞϥΠζυϏϡʔ ֎෦ςʔϒϧ΁ͷॻ͖ग़͠ ΠϕϯττϦΨ  σʔλϖʔδɾνΣοΫαϜ -"5&3"-۟  +40/#ܕ 42-͔Βͷαʔόʔઃఆͷมߋ ϨϓϦέʔγϣϯεϩοτ  614&35ػೳ ϒϩοΫϨϯδΠϯσοΫε ߦ୯ҐηΩϡϦςΟ੍ޚίϚϯυ  ύϥϨϧΫΤϦ ෳ਺ಉ࣌ελϯόΠ શจݕࡧͷϑϨʔζରԠ  $01:จͷSFUVSOJOH۟ରԠ ܥ͚ͩͰ΋ࡌ͖ͤΕͳ͍΄Ͳͷػೳ௥Ճ΍վળ ʹϦϦʔε͞Εͨ͸ ݸͷػೳ௥Ճ΍վળ͕͋Δʂ
  5. ܥ࣌୅   ˞ͷ࣍͸ͰܾఆࡁΈ ܥ࣌୅ ݱࡏ   ϨϓϦέʔγϣϯ Ұׅݖݶมߋ

    ಗ໊ϓϩγʔδϟ CJU8JOEPXTαϙʔτ  Ҡಈฏۉ ྻ৚݅τϦΨ Ұҙੑ੍໿ͷ஗Ԇ ഉଞ੍໿  ಉظϨϓϦέʔγϣϯ ֎෦ςʔϒϧ ύοέʔδ؅ཧ 6/-0((&%ςʔϒϧ  ߋ৽Մೳͳ8*5)۟ ۙ๣ݕࡧ 4&-JOVYݖݶ੍ޚ  ΠϯσοΫεΦϯϦʔεΩϟϯ ΧεέʔυϨϓϦέʔγϣϯ +40/ܕ ൣғܕ  ϚςϦΞϥΠζυϏϡʔ ֎෦ςʔϒϧ΁ͷॻ͖ग़͠ ΠϕϯττϦΨ  σʔλϖʔδɾνΣοΫαϜ -"5&3"-۟  +40/#ܕ 42-͔Βͷαʔόʔઃఆͷมߋ ϨϓϦέʔγϣϯεϩοτ  614&35ػೳ ϒϩοΫϨϯδΠϯσοΫε ߦ୯ҐηΩϡϦςΟ੍ޚίϚϯυ  ύϥϨϧΫΤϦ ෳ਺ಉ࣌ελϯόΠ શจݕࡧͷϑϨʔζରԠ  $01:จͷSFUVSOJOH۟ରԠ ܥ͚ͩͰ΋ࡌ͖ͤΕͳ͍΄Ͳͷػೳ௥Ճ΍վળ ʹϦϦʔε͞Εͨ͸ ݸͷػೳ௥Ճ΍վળ͕͋Δʂ ೥ʑ։ൃ͕׆ੑԽ͍ͯ͠Δ
  6. What is it? • 6ܥ ඪ४SQLʹ४ڌ͠ɺMVCCͳͲͷRDBMSͱͯ͠ͷ
 جຊతͳػೳΛ࣮૷ • 7ܥ ੍໿΍WALΛखʹೖΕͯACIDΛຬͨ͢

    • 8ܥ VACUUM΍HOTͳͲͷӡ༻ʹ
 ௚݁͢ΔύϑΥʔϚϯεվળ • 9ܥ ϨϓϦέʔγϣϯ΍OLTPɾDWH྆ํͷ໘Ͱੑೳ޲্
  7. ܥ࣌୅    ෭໰߹ͤ 1-5DM  1-QH42- 7JFX 

    ϚϧνόΠτจࣈྻαϙʔτ  .7$$ Ұ࣌ද $"4&  */5&34&$5 &9$&15 ܥ࣌୅    ֎෦Ωʔ੍໿  8"- 50"45 065&3+0*/  ίϯΧϨϯτ7"$66.  1-1ZUIPO  εΩʔϚ υϝΠϯ 13&1"3&  *1W JOGPSNBUJPO@TDIFNB ܥ࣌୅    .JDSPTPGU8JOEPXTରԠ  4"7&10*/5 1*53 දྖҬ  ૬ίϛοτ 30-& ߦڞ༗ϩοΫ  ςʔϒϧɾύʔςΟγϣχϯά  ΢ΥʔϜελϯόΠ (*/  ߋ৽ॲཧੑೳͷ޲্ 9.-σʔλܕ  શจݕࡧ +*49  &/6.ܕ 66*%ܕ  ࠶ؼΫΤϦ ΢Οϯυ΢ؔ਺  ྻ୯ҐͷΞΫηε੍ޚ 42-ͱؔ਺ͷੑೳղੳػೳ