There's definitely a lot deeper I can go on this, this is largely a test of a series which could go quite deep. My initial post yesterday simply highlighted one

There's definitely a lot deeper I can go on this, this is largely a test of a series which could go quite deep. My initial post yesterday simply highlighted one method of indexing and out of that came many of the questions in here. In general Postgres is pretty flexible with what you can index with not many limitations, its impact on the rest of the schema aren't always so simple so would love to hear what you have in mind as impact. Please feel free to drop me a line and would love to turn more of that into a deeper post.