pganalyze: - Weekly series "5mins of Postgres": - How Postgres chooses which index to use: - CMU databases courses: - Postgres community: As well as social links: - Mastodon: - Twitter/X: @pganalyze, @LukasFittl - GitHub: @pganalyze, @lfittl - LinkedIn.
<p>In this video, I explain how both Postgres and MySQL store their indexes and their effect on reads vs writes. Let us discuss</p>
<p><br></p>
<p>0:00 Intro</p>
<p>1:00 Tables</p>
<p>2:00 Indexes</p>
<p>3:20 Indexing in Postgres</p>
<p>5:00 Indexing in MySQL</p>
<p>6:35 What Hap ... Show More
