owned this note   changed 6 years ago  
Linked with GitHub

Do You Select PostgreSQL or MySQL? - 曽根 壮大

由於場地問題，第二天我們移動到另一棟大樓啦！議程教室變動請見網站上的議程表。

歡迎來到 https://hackmd.io/@coscup/2019 共筆

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

點擊本頁上方的 開始用 Markdown 一起寫筆記！
手機版請點選上方 按鈕展開議程列表。

@soudai1025: Today's slide will be released /Do You Select PostgreSQL or MySQL ?

https://t.co/EsQgZFjABd

#COSCUP #TR409_1

請從這裡開始

Architectural Diffs:
MySQL–multi-threaded
Postgres–multi-Process

  • Instead of deciding who is better, this talk is to illustrate the differences between them?

Difference between MySQL and PostgreSQL

  • Server architecture
    • MySQL → multi-thread
    • PostgresSQL → multi-process
  • Licence
    • MySQL → GPL v2 or Commercial License
    • PostgresSQL → PostgresSQL License
  • The Development Style
    • MySQL → Oracle
    • PostgresSQL → Community

Advantage of MySQL

  • Extensibility

  • Good at fetching by pk and pk update

  • Flexible replication

    • Multi source replication
    • Group Replication → Multi Master

  • Document Store

    • JSON type → schema-less table

Advantage of PostgreSQL

  • Parallel Query
    • but not to increase number of workers beyond number of CPU core
  • Materialized View
  • Foreign Data Wrapper → an external table handle for your own table (other DBMS)
    • support WHERE, JOIN, GROUP BY, DELETE & UPDATE
    • Any data store is acceptable
  • GIN INDEX & Function INDEX + JSON
tags: COSCUP2019 PostgreSQL IB302
Select a repo