Hi,
I've inserted 10 random boxes into a table and created a rtree index
on it. Indexing needed a few minutes and finally I got a 200MB page file
for the index. Can someone explain this to me?
BTW: I did the same with Oracle 8i Spatial and the index seems to be a
lot smaller. Selection time
digits accuracy.
still searching for an explanation,
Christopher
> try to vacuum database :
> connect on your psql term on your database then
> "VACUUM [VERBOSE] ANALYZE" it. It will clean
> the blank spaces and re-organize the indexes.
> Oracle seems to do it automaticaly.
&
Hi,
I've inserted 10 random boxes into a table (page file size about 8M) and
created a rtree index on it. Indexing needed a few minutes and finally I got
a 200MB page file for the index. Can someone explain this to me?
BTW: I did the same with Oracle 8i Spatial and the index seems to be a
