Presto Community Broadcast

By: Presto Community
Listen for free

  • Summary

  • Presto Community Broadcast is a show where we cover events and happenings within the open-source Presto community and show off some cool stuff about Presto. Learn more at https://prestosql.io
    ℗ & © 2020 Presto Community Broadcast
    Show More Show Less
Show More Show Less
activate_samplebutton_t1
Episodes
  • 7: Cost Based Optimizer, Decorrelate subqueries, and does Presto make my RDBMS faster?

    7: Cost Based Optimizer, Decorrelate subqueries, and does Presto make my RDBMS faster?
    Dec 21 2020

    Table of Contents:

    - Intro Song: 00:00

    - Intro: 00:20

    - News: 3:27

    - Concept of the week: Cost Based Optimizer 16:48

    - PR of the week: PR 1415 Decorrelate subqueries with Limit or TopN 43:09

    - PR Demo: EXPLAIN Decorrelate subqueries with Limit or TopN 53:36

    - Question of the week: Will running Presto on my relational database make processing faster? 1:02:24

    Show Notes: https://prestosql.io/episodes/7.html

    Show Page: https://prestosql.io/broadcast/
    Show More Show Less
    1 hr and 12 mins
  • 6: Query Planning, Remove duplicate predicates, and Memory settings

    6: Query Planning, Remove duplicate predicates, and Memory settings
    Dec 7 2020

    Table of Contents:

    - Intro Song: 00:00

    - Intro: 00:20

    - News: 12:32

    - Concept of the week: Query Planning 20:31

    - PR of the week: PR 730 Remove duplicate predicates 29:55

    - PR Demo: Remove duplicate predicates demo 33:47

    - Question of the week: How should I allocate memory properties? 54:49

    Show Notes: https://prestosql.io/episodes/6.html

    Show Page: https://prestosql.io/broadcast/
    Show More Show Less
    1 hr and 11 mins
  • 5: Hive Partitions, sync_partition_metadata, and Query Exceeded Max Columns!

    5: Hive Partitions, sync_partition_metadata, and Query Exceeded Max Columns!
    Nov 23 2020

    Table of Contents:

    - Intro Song: 00:00

    - Intro: 00:20

    - News: 05:26

    - Concept of the week: Hive Partitioning 19:12

    - PR of the week: PR 223 Add system.sync_partition_metadata procedure to sync Hive table partitions 29:20

    - PR Demo: system.sync_partition_metadata procedure demo 34:57

    - Question of the week: Why am I getting, 'Query exceeded maximum columns.' error? 1:00:56

    Show Notes: https://prestosql.io/episodes/5.html

    Show Page: https://prestosql.io/broadcast/
    Show More Show Less
    1 hr and 8 mins

What listeners say about Presto Community Broadcast

Average Customer Ratings

Reviews - Please select the tabs below to change the source of reviews.

Audible.com.au reviews

Amazon Reviews
No Reviews are Available
In the spirit of reconciliation, Audible acknowledges the Traditional Custodians of country throughout Australia and their connections to land, sea and community. We pay our respect to their elders past and present and extend that respect to all Aboriginal and Torres Strait Islander peoples today.