From: Greg Stark <gsstark@mit.edu>
To: Oleg Bartunov <oleg@sai.msu.su>
Cc: Greg Stark <gsstark@mit.edu>
Cc: Achilleus Mantzios <achill@matrix.gatewaynet.com>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Cc: Teodor Sigaev <teodor@stack.net>
Subject: Re: Gist indexes on int arrays
Date: 04 Mar 2003 15:40:34 -0500
Message-ID: <87llzukgql.fsf@stark.dyndns.tv> (raw)
In-Reply-To: <Pine.GSO.4.53.0303042309410.15273@ra.sai.msu.su>
References: <Pine.LNX.4.44.0303040934040.26498-100000@matrix.gatewaynet.com>
<87smu3kv7d.fsf@stark.dyndns.tv>
<87k7ffkr3o.fsf@stark.dyndns.tv>
<Pine.GSO.4.53.0303042110580.15273@ra.sai.msu.su>
<87znobj7u0.fsf@stark.dyndns.tv>
<Pine.GSO.4.53.0303042309410.15273@ra.sai.msu.su>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gsstark@mit.edu, oleg@sai.msu.su, achill@matrix.gatewaynet.com, teodor@stack.net
Subject: Re: Gist indexes on int arrays
In-Reply-To: <87llzukgql.fsf@stark.dyndns.tv>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox