Lesson 4, PostgreSQL Indexes, Ordering, and Hypertables
Get an overview of indexes, ordering, and hypertables.
📝 𝗔𝗯𝗼𝘂𝘁 𝗙𝗼𝘂𝗻𝗱𝗮𝘁𝗶𝗼𝗻𝘀 𝗼𝗳 𝗣𝗼𝘀𝘁𝗴𝗿𝗲𝗦𝗤𝗟 & 𝗧𝗶𝗺𝗲𝘀𝗰𝗮𝗹𝗲𝗗𝗕 𝗖𝗼𝘂𝗿𝘀𝗲
This course is designed for beginners to SQL and database management systems. Throughout the course, we’ll be looking at various topics including schema design, basic schema design, compression, JOINs, and much more.
🛠 𝗥𝗲𝗹𝗲𝘃𝗮𝗻𝘁 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀
📌 Foundations of PostgreSQL & TimescaleDB course playlist ⇒ • Course: Foundations of PostgreSQL & T...
📌 Index, A History of the: A Bookish Adventure from Medieval Manuscripts to the Digital Age ⇒ https://bookshop.org/books/index-a-hi...
🐯 𝗔𝗯𝗼𝘂𝘁 𝗧𝗶𝗺𝗲𝘀𝗰𝗮𝗹𝗲
At Timescale, we are dedicated to serving developers worldwide, enabling them to build exceptional data-driven products that measure everything that matters. Analyzing this data across the time dimension ("time-series data") enables developers to understand what is happening right now, how that is changing, and why that is changing. We are backed by top-tier investors with a track record of success in the industry.
💻 𝗙𝗶𝗻𝗱 𝗨𝘀 𝗢𝗻𝗹𝗶𝗻𝗲!
🔍 Website ⇒ https://tsdb.co/homepage
🔍 Slack ⇒ https://slack.timescale.com
🔍 GitHub ⇒ https://github.com/timescale
🔍 Twitter ⇒ / timescaledb
🔍 Twitch ⇒ / timescaledb
🔍 LinkedIn ⇒ / timescaledb
🔍 Timescale Blog ⇒ https://tsdb.co/blog
🔍 Timescale Documentation ⇒ https://tsdb.co/docs
📚 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
⏱ 5:00 ⇒ Introduction
⏱ 7:30 ⇒ Index, A History of the: A Bookish Adventure from Medieval Manuscripts to the Digital Age
⏱ 9:30 ⇒ Order
⏱ 11:49 ⇒ Alphabetical BTree
⏱ 14:05 ⇒ Indexes and ordering 1.1- Sequential vs Random Reads
⏱ 20:35 ⇒ Disk Blocks & Codexes
⏱ 26:40 ⇒ Avoid some heap lookups by INCLUDE - ing columns
⏱ 27:30 ⇒ CLUSTER / REORDER
⏱ 28:40 ⇒ Indexes and ordering 1.2- Multi-column indexes
⏱ 38:00 ⇒ Time-series tables
⏱ 50:10 ⇒ What's a partition?
⏱ 52:20 ⇒ What is a hypertable?
⏱ 1:06:24 ⇒ Indexes and ordering 1.3- Unique indexes & Partitions
Watch video Lesson 4, PostgreSQL Indexes, Ordering, and Hypertables online without registration, duration hours minute second in high quality. This video was added by user Timescale 21 April 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,405 once and liked it 47 people.