I think it would be impossible to get good performance using normal (one dimensional) indices. The problem is, when your time-zone information changes, you'd n

I think it would be impossible to get good performance using normal (one dimensional) indices. The problem is, when your time-zone information changes, you'd need to recalculate all your materialized views. Most popular databases lock the index/materialized view when it is being rebuild, blocking all access. When your tables are in the order of 1B rows, you can't really afford that.