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.
-
3:17
Morgonn
16 hours agoStudent Loans are CRIPPLING Gen Z! How much debt do you have???
3.88K20 -
23:53
Science & Futurism with Isaac Arthur
1 day agoStatites, Lagites, and Quasites
6.87K3 -
6:05
SaturdayMorningInspection
16 hours agoLions Pulled Off A HIGH VALUE Move
5.81K2 -
5:17
Bear Creek Arsenal
21 hours ago6.5 Grendel vs. 6mm ARC vs. .224 Valkyrie [Which is Best?]
7.2K1 -
3:36
Michael Heaver
23 hours agoUK’s Block Triggers Unbelievable EU U-TURN
3.32K12 -
48:20
Crime Circus
1 day agoFlorida Man's Nightmare: The Shocking Interrogation & Wrongful Arrest
4.51K4 -
19:32
Crypto Crew University
15 hours agoWARNING: BITCOIN IS ABOUT TO DO SOMETHING THAT CAUSED HUGE CRASH LAST TIME – CAN IT BE AVOIDED
5.08K -
2:59:18
Fresh and Fit
9 hours agoDELUSIONAL 40 yr Old Argues Men Prefer "OLDER" Women?!
112K145 -
3:43:35
Alex Zedra
9 hours agoLIVE! Giving away an M249 SAW | PJ Party + Games
39K11 -
29:23
Standpoint with Gabe Groisman
17 hours agoEp. 21. Can Israel "End Hamas"? IDF Brig. General Res. Amir Avivi, Founder of IDSF
43.8K51