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
Смотрите видео Lesson 4, PostgreSQL Indexes, Ordering, and Hypertables онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Timescale 21 Апрель 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,405 раз и оно понравилось 47 людям.