Of course. But my question pertains _how_ the event data is stored. Heap stored the event data in Citus, and OP worked to optimize their PostgreSQL for queries

Of course. But my question pertains _how_ the event data is stored. Heap stored the event data in Citus, and OP worked to optimize their PostgreSQL for queries across the data. Freshpaint doesn't query the data (in the aggregate form that Heap does), it simply needs to find events that qualify as defined events and forward them to their destinations. I'm just asking if PostgreSQL is still the right tool for that.