Postgres FM cover image

Read-only considerations

Postgres FM

00:00

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

Transcript
Play full episode

The AI-powered Podcast Player

Save insights by tapping your headphones, chat with episodes, discover the best highlights - and more!
App store bannerPlay store banner
Get the app