From: Valentine Gogichashvili <valgog@gmail.com>
To: Oleg Bartunov <oleg@sai.msu.su>
Cc: pgsql-performance@postgresql.org
Subject: Re: Cannot make GIN intarray index be used by the planner
Date: Wed, 9 May 2007 15:36:44 +0200
Message-ID: <3ce9822f0705090636s46b71c48mafb6ba7d64781fbf@mail.gmail.com> (raw)
In-Reply-To: <Pine.LNX.4.64.0705091728560.12152@sn.sai.msu.ru>
References: <3ce9822f0705090612nd6198a2xd06da85f1accbae9@mail.gmail.com>
<Pine.LNX.4.64.0705091728560.12152@sn.sai.msu.ru>
I have experimented quite a lot. So first I did when starting the attempt to
move from GiST to GIN, was to drop the GiST index and create a brand new GIN
index... after that did not bring the results, I started to create all this
tables with different sets of indexes and so on...
So the answer to the question is: no there in only GIN index on the table.
Thank you in advance,
Valentine
On 5/9/07, Oleg Bartunov <oleg@sai.msu.su> wrote:
>
> Do you have both indexes (GiST, GIN) on the same table ?
>
> On Wed, 9 May 2007, Valentine Gogichashvili wrote:
>
> > Hello all,
> >
> > I am trying to move from GiST intarray index to GIN intarray index, but
> my
> > GIN index is not being used by the planner.
> >
> > The normal query is like that
> >
> > select *
> > from sourcetablewith_int4
> > where ARRAY[myint] <@ myint_array
> > and some_other_filters
> >
> > (with GiST index everything works fine, but GIN index is not being used)
> >
> > If I create the same table populating it with text[] data like
> >
> > select myint_array::text[] as myint_array_as_textarray
> > into newtablewith_text
> > from sourcetablewith_int4
> >
> > and then create a GIN index using this new text[] column
> >
> > the planner starts to use the index and queries run with grate speed
> when
> > the query looks like that:
> >
> > select *
> > from newtablewith_text
> > where ARRAY['myint'] <@ myint_array_as_textarray
> > and some_other_filters
> >
> > Where the problem can be with _int4 GIN index in this constellation?
> >
> > by now the enable_seqscan is set to off in the configuration.
> >
> > With best regards,
> >
> > -- Valentine Gogichashvili
> >
>
> Regards,
> Oleg
> _____________________________________________________________
> Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
> Sternberg Astronomical Institute, Moscow University, Russia
> Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
> phone: +007(495)939-16-83, +007(495)939-23-83
>
--
ვალენტინ გოგიჩაშვილი
Valentine Gogichashvili
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-performance@postgresql.org
Cc: valgog@gmail.com, oleg@sai.msu.su
Subject: Re: Cannot make GIN intarray index be used by the planner
In-Reply-To: <3ce9822f0705090636s46b71c48mafb6ba7d64781fbf@mail.gmail.com>
* 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