title: Postgresql : Index on partition table
body: <p>I am from SQL Server background so very limited knowledge in Postgres.</p>
  <p>We have a partition table with more than 100 partitions based on clientid.
  queries to that table is being very slow so planning to create an index on that partition.</p>
  <p>I did refer Postgres manual, everywhere it tells to create index on  partition then i will end up creating more than 100 indexes in table.</p>
  <p>Do we have any global partition index which will cover all partition in Postgres?</p>