On 01.06.2011 10:48, Nick Raj wrote:
> On Tue, May 31, 2011 at 12:46 PM, Heikki Linnakangas<
> heikki.linnakangas@enterprisedb.com> wrote:
>> If not, please post a self-contained test case to create and populate the
>> table, so that others can easily try to reproduce it.
>>
>
> I have attached .sql file that having 20000 tuples
> Table creation - create table cubtest(c cube);
> Index creation - create index t on cubtest using gist(c);
Ok, I can reproduce the issue with that. The index is only 4MB in size
when I populate it with random data (vs. 15 MB with your data). The
command I used is:
INSERT INTO cubtest SELECT cube(random(), random()) FROM
generate_series(1,20000);
My guess is that the picksplit algorithm performs poorly with that data.
Unfortunately, I have no idea how to improve that.
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com