1,400 Times Faster Max & Group By Performance | Scaling Postgres 311

Поділитися
Вставка
  • Опубліковано 15 вер 2024

КОМЕНТАРІ • 7

  • @jocketf3083
    @jocketf3083 5 місяців тому +1

    Thank you for another great episode!

  • @rosendo3219
    @rosendo3219 5 місяців тому

    macos compilation post is super useful. huge thanks Creston!

    • @ScalingPostgres
      @ScalingPostgres  5 місяців тому

      Haha, I just report on the content. The kudos definitely goes to Andrew.

  • @rosendo3219
    @rosendo3219 5 місяців тому

    omg redgate part 2 released

  • @utenatenjou2139
    @utenatenjou2139 5 місяців тому +1

    Interesting, these type of aggregate for each, with extremely large scale, I may design partition (hash) on the id. I don't know how parallelism will do in postgres, I might try that., 14:56 merge/split is nice but lock, reduce the real world implementation, hope there are patch on it. 16:38, totally agree, with the rise of DPO data protection officer, and its regulation requirement, database layer encryption become a hurdle to pick PostgreSQL, there are time that mysql win because of the burden to get security exemption needed to do on postgres.