Have you timed it both with and without the separate btree? It could
be that using the 2 indexes is actually faster.
On Mar 10, 2007, at 4:19 AM, Arnaud Lesauvage wrote:
Hi list !
I have a quite large table with a PostGIS-geometry field (~25M
rows) representing road segments.
The segments
Hi list !
I have a quite large table with a PostGIS-geometry field (~25M rows)
representing road segments.
The segments are classified in 9 classes (from 0 to 8), based on their
importance.
I am trying some different methods for optimizing queries on this table.
I decided to try with a multicol
