Re: Gist indexes on int arrays

Oleg Bartunov <oleg(at)sai(dot)msu(dot)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