[postgis-users] Partitioning spatial table

[Michael Fuhr]

On Sun, Feb 19, 2006 at 03:08:53PM -0500, Bill Binko wrote:
> On Sun, 2006-02-19 at 10:06 -0600, David Bitner wrote:
> > Will the new multi-index capabilities in 8.1 make a difference?
> 
> I don't know the answer to that, unfortunately, although I think that to
> expect a multi-column index with one of the columns being a geometry to
> perform well is awfully optimistic.
> 
> Remember that if you think about a multi-column index in a standard
> relational database, the DB just does a concatenation of the fields and
> indexes the results.  That's why the order of the fields is so important
> in defining indexes, and why you often need "duplicate" indexes with
> only the order changed.

By "multi-index capabilities" I wonder if David is referring to
8.1's bitmap scans, which allow the planner to make use of disparate
indexes.

-- 
Michael Fuhr