title: How can I use an index on a partitioned table in postgresql 8.3.7
body: <p>I have situation, where running a query that filters by an indexed column in a partitioned table, performs a full table scan.</p>
  
  <p>Apparently , this is a known issue in postgresql, and it's explained in detail <a href="http://benjamin.smedbergs.us/blog/tag/postgresql/" rel="noreferrer">here</a>.</p>
  
  <p>Is there a more elegant way around this other than performing a query on each partition, and then performing a UNION on all of the results?</p>