Rolling out 1M Postgres indexes

heap.io

13 pointskmdupree2 comments

I'm not sure how/why a new event type would need a new index. Is each new event type stored in a separate table?

Great question! I should have been clearer. Each event type gets a new partial index where the WHERE clause of the partial index corresponds to the properties of the new event type.

Hope that clarifies! Lmk if not. :)

Reply on news.ycombinator.com