in postgres, can one optimize a table across partitions?
the question is whether there is any way to optimize at the global level. for example, would it be possible to create an index on global.usr_id that would span all partitions?


Sadly the answer is "No" - global indexes are not currently supported