From: Oleg Bartunov <oleg@sai.msu.su>
To: Greg Stark <gsstark@MIT.EDU>
Cc: Achilleus Mantzios <achill@matrix.gatewaynet.com>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: Gist indexes on int arrays
Date: Tue, 4 Mar 2003 21:16:41 +0300 (MSK)
Message-ID: <Pine.GSO.4.53.0303042110580.15273@ra.sai.msu.su> (raw)
In-Reply-To: <87k7ffkr3o.fsf@stark.dyndns.tv>
References: <Pine.LNX.4.44.0303040934040.26498-100000@matrix.gatewaynet.com>
<87smu3kv7d.fsf@stark.dyndns.tv>
<87k7ffkr3o.fsf@stark.dyndns.tv>
On Tue, 4 Mar 2003, Greg Stark wrote:
>
> Greg Stark <gsstark@MIT.EDU> writes:
>
> > Can I have a GiST index on (foo_id, attribute_set_array) and have it be just
> > as fast at narrowing the search to just foo_id = 900 but also speed up the ~
> > operation?
>
> Hm, so if I understand what I'm reading I can do this if I load the btree_gist
> contrib module as well. I'm still not sure whether it'll be worthwhile for
> this application though.
>
> I have a bit of a problem though. Is building GiST indexes supposed to take
> much much longer than building btree indexes? It's been running nearly an hour
> and it's still going. The hard drive is hardly moving so it seems to be all
> cpu usage. I don't even see any pgsql_tmp usage.
>
> db=# CREATE INDEX cache_gist_idx on cache using gist ( foo_id , attribute_set gist__int_ops);
>
> postgres 30176 86.3 22.2 64896 57344 ? R 11:08 40:32 postgres: postgres slo [local] CREATE INDEX
>
>
> I don't remember exact numbers but building the normal btree index took on the
> order of 15m. This will have to be rebuilt nightly, an hour long index build
> won't be practical.
what's the time to create gist indices separately ? I suppose 15m is the time
to create btree index on *single* column ?
>
> --
> greg
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
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: oleg@sai.msu.su, gsstark@MIT.EDU, achill@matrix.gatewaynet.com
Subject: Re: Gist indexes on int arrays
In-Reply-To: <Pine.GSO.4.53.0303042110580.15273@ra.sai.msu.su>
* 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