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.
-
1:06:32
barstoolsports
1 hour agoMom Life Isn't Always Easy But It's Worth It | Barstool Mother's Day Special
1101 -
33:31
SLS - Street League Skateboarding
2 days agoAll the 9's - SLS San Diego 2024
2.44K3 -
LIVE
Midnight's Edge
3 hours agoMark Hamill Debases Star Wars for May 4th, Helldivers 2 make a full PSN Retreat! | MEiTM #557
885 watching -
6:12:53
PudgeTV
14 hours ago🟠Elden Ring - Mourning Death Count Ep 22 | Monday Mourning Mayhem | Weekly Update
4.98K1 -
1:37:41
The Shannon Joy Show
5 hours ago🔥We Were RIGHT About Everything! NYTimes FINALLY Admits Jab Injuries. Exclusive W/Jeffrey Tucker!🔥
5.53K19 -
LIVE
jeffahern
1 hour agoMonday Madness with Jeff Ahern (9am Pacific)
729 watching -
LIVE
Trumpet Daily
1 hour agoDinesh D'Souza Interview - Trumpet Daily | May 6, 2024
1,213 watching -
52:42
The Peer to Peer Podcast
2 hours agoIs DC 'West Wing' or 'Veep?'
9.93K1 -
58:37
The Dan Bongino Show
3 hours agoSPECIAL: Best Of The Dan Bongino Show - 05/06/2024
118K462 -
1:07:48
Steven Crowder
4 hours agoWho is Trump's VP? The Short List is Here: Kristi Noem Self-Destructs!
202K508