Tabular Office Hours: June 14, 2023
00:00 Intro
05:34 Three main factors affecting cost
11:10 Tabular's optimization techniques
16:34 Illustrate cost savings
22:23 Summary
Series: Tabular Office Hours
Guest: Jason Reid, Tabular co-founder and head of product
Subject: Cost Optimization
Jason reviews how to optimize costs on AWS Object Store and how Tabular does it for you automatically.
AI Generated Summary:
- James Reed, co-founder of Tabular, discussed the benefits of automatic table optimization for cloud data warehousing, which can lower costs and improve query performance. He explained the three components of cost for data warehousing (network, storage, and compute) and provided examples of pricing models, such as Amazon Athena's pricing based on data volume. -
- Jason discussed the three main factors that affect the cost of running a cloud data warehouse environment: network, storage, and compute. He also explained how Tabular's automated optimization techniques can reduce costs by organizing data more effectively and executing compute in the background.
- Jason discussed how Tabular's platform handles optimization through sorting, compression, and compaction. The platform constantly experiments with different compression settings to find the best combination of size, write performance, and read performance for each table, resulting in a 50-80% reduction in overall data size and significant cost savings.
- Jason discussed how Tabular's table optimization can significantly reduce the cost of data warehousing bills by compacting and organizing data into a smaller set of bytes. He demonstrated this through a demo where a table with 434,000 rows and 175 megabytes worth of data was optimized to just over 100 megabytes, resulting in a 40% overall savings on the cost of that workload.
- Jason explained how sorting and organizing the data helped to significantly reduce the amount of data that needed to be loaded, resulting in faster response times and lower costs. The team was excited about the optimization features in Tabular.
-
2:05:36
Matt Kohrs
11 hours agoNew Highs Incoming, Yield Curve Reinverts & The Week Ahead || The MK Show
23.4K4 -
43:10
BonginoReport
5 hours agoWe're Toast: Kamala Harris Joins 'Call Her Daddy' Sex Podcast (Ep.58) - 10/07/24
51.2K154 -
1:18:58
Jeff Ahern
3 hours agoMonday Madness With Jeff Ahern
12.9K5 -
1:35:45
Game On!
11 hours agoThe SHOCKING results from a chaotic football weekend!
16.4K1 -
13:03
Colion Noir
19 hours agoElon Musk Passionately Defends The Second Amendment At Trump Rally
40.1K69 -
7:34
Misha Petrov
1 day agoAmericans Left to Suffer After FEMA’s Failed Response To Hurricane Helene
32.3K64 -
4:53
DEADBUGsays
1 day agoLondon's Necrophiliac Killer | DEADBUG's 2 Minute Murder
27.2K6 -
31:04
World Nomac
20 hours ago$10 Hotel vs. $200 Hotel in Pakistan 🇵🇰
30.3K3 -
6:50
Quite Frankly
20 hours agoIBS, Gut Health, and Matt Walsh's War on Raw Milk
33K8 -
26:26
Danny Haiphong
18 hours ago $0.07 earnedIsrael is DONE: Iran, Hezbollah, Yemen & Iraq Ready to CRUSH IDF w/ Prof. Mohammad Marandi
27.5K75