[postgis-users] Partitioning spatial table

[David Bitner]

Yep, that's exactly what I was referring to -- sorry for the lack of detail.

On 2/19/06, Michael Fuhr <mike at fuhr.org> wrote:
> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>