[postgis-users] Partitioning spatial table

[Markus Schaber]

Hi, David,

David Bitner wrote:

> The table that I have that the bitmap indices excite me about is a
> table of flight track records where the main two search criteria are
> time (start, end as attributes-- not necessarily a 4th d) and place. 
> In addition I also need to do dozens of queries using various other
> fields (what airport, arrival or departure, aircraft type, etc...). It
> is the huge list of unpredictable queries that make me interested in
> the bitmap index.
>
> My assumption is that the bitmap will deal with both GIST and BTREE so
> it won't matter to mix and match (unlike creating a multi-column).  Is
> this the case?

To be honest, I don't know.

I can only suggest to test it, or ask on the PostgreSQL Performance List
<pgsql-performance at postgresql.org> - this is where the gurus meditate :-)


HTH,
Markus
-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org