Re: [GENERAL] multicolumn GIST index question

2005-03-01 Thread Greg Stark
> Ron Mayer wrote: > > Did anyone get multi-column GIST indexes working using both > > the gist_btree and postgis modules? Multi-column gist indexes are basically useless at this point. The index pages are split based entirely on the first column, so the index becomes basically an index on the fi

Re: [GENERAL] multicolumn GIST index question

2005-03-01 Thread Teodor Sigaev
Did anyone get multi-column GIST indexes working using both the gist_btree and postgis modules? It must. fl=# -- sessionid is a text; the_geom is a GEOMETRY fl=# create index testidx2 on user_point_features using gist (sessionid,the_geom); server closed the connection unexpectedly This pr

Re: [GENERAL] multicolumn GIST index question

2005-02-28 Thread Sebastian Böck
Ron Mayer wrote: Did anyone get multi-column GIST indexes working using both the gist_btree and postgis modules? Not quite stable yet. It seems to work fine for me on small test cases (shown at the bottom), but seems to crash my database for large ones. Any advice is welcome - including pointers

[GENERAL] multicolumn GIST index question

2005-02-28 Thread Ron Mayer
Did anyone get multi-column GIST indexes working using both the gist_btree and postgis modules? It seems to work fine for me on small test cases (shown at the bottom), but seems to crash my database for large ones. Any advice is welcome - including pointers to better lists to ask questions like t