Re: Gist indexes on int arrays - Mailing list pgsql-sql

From Greg Stark
Subject Re: Gist indexes on int arrays
Date
Msg-id 87llzukgql.fsf@stark.dyndns.tv
Whole thread Raw
In response to Re: Gist indexes on int arrays  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-sql
Oleg Bartunov <oleg@sai.msu.su> writes:

> On Tue, 4 Mar 2003, Greg Stark wrote:
> 
> > > > db=# CREATE INDEX cache_gist_idx on cache using gist ( foo_id , attribute_set gist__int_ops);
> >
> > There are 1,161,435 records, with 384 distinct values of foo_id. The number of
> > records per value of foo_id ranges from 1 to 11,474.
> 
> hmm, not so much. We might be interested to play with the data.
> How big would be compressed archive of your data, so we could download
> it and use as test data.

The -Fc archive is 20M. But I have to get permission from the client.

It's nearly 5h now. Surely something is wrong?

postgres 30176 92.2 21.4 77124 55092 ?       R    11:08 247:48 postgres: postgres slo [local] CREATE INDEX

This is 7.3 btw, would I have better success with CVS?

-- 
greg



pgsql-sql by date:

Previous
From: Jean-Luc Lachance
Date:
Subject: Re: Forcing query to use an index
Next
From: Tomasz Myrta
Date:
Subject: Re: LIMIT and SUBQUERIES