rtree index very large

From: Christopher Zach <zach(at)icg(dot)tu-graz(dot)ac(dot)at>
To: pgsql-general(at)postgresql(dot)org
Subject: rtree index very large
Date: 2001-06-12 15:17:20
Message-ID: 01061211172000.15471@fcggpc47.icg.tu-graz.ac.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I've inserted 100000 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
lot smaller. Selection time for geometric queries (non-empty
intersection with a box) is roughly the same - a few seconds for both
2DBMS, but I don't have exact statistics.

I can guess a possible explanation for the smaller index in Oracle:
coordinates are rounded according the given accuracy, which could result
in smaller rtrees, but this is just a guess.

regards,

Christopher

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martín Marqués 2001-06-12 15:28:39 Re: Permissions & Ownership (BUG?)
Previous Message Martín Marqués 2001-06-12 15:17:13 Re: tables, permissions, sequences