Read-only considerations
Postgres FM
Bringing Indexes to Databases
There's a chance, for example, the examples I've seen in these are often quite time series, heavy use cases. There's a chance your data will already be ordered. This reminds us of brain index as well. So yeah, making sure it ends up in order is the, is feels like a good one. Right. We don't have delete updates or inserts, so we know that it won't change during day. For the status frozen, it's a perfect situation. Yeah. If you're familiar with other databases, this is what people often call index organized tables. And it makes a lot of sense. Okay. Well, I wanted to bring up bringing indexes, because
00:00
Transcript
Play full episode
Remember Everything You Learn from Podcasts
Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.
