Postgres FM cover image

Read-only considerations

Postgres FM

CHAPTER

Index Only Scans for Critical Queries

There's a couple of other things in terms of queries that you can do to favor index only scan. Just checking that you do need all columns that are being requested. So I would fight hard to have single index only scan in most critical queries. In this case, I know this is the best performance pause was kind of kind of give me. But then my question is what's the state or your of your buffer pool and the file cache? Is it good? Because you started to keep the same data multiple multiple times, like many times, the same records,. basically, you have denormalized the situation. And probably you need more memory to keep because you have more pages. It

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.
App store bannerPlay store banner