From: | "Valentine Gogichashvili" <valgog(at)gmail(dot)com> |
---|---|
To: | "Oleg Bartunov" <oleg(at)sai(dot)msu(dot)su> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Cannot make GIN intarray index be used by the planner |
Date: | 2007-05-09 13:36:44 |
Message-ID: | 3ce9822f0705090636s46b71c48mafb6ba7d64781fbf@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-performance |
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(at)sai(dot)msu(dot)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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
> phone: +007(495)939-16-83, +007(495)939-23-83
>
--
ვალენტინ გოგიჩაშვილი
Valentine Gogichashvili
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 2007-05-09 13:49:36 | Re: Cannot make GIN intarray index be used by the planner |
Previous Message | Oleg Bartunov | 2007-05-09 13:31:19 | Re: Cannot make GIN intarray index be used by the planner |
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Cristian Cruz | 2007-05-09 13:38:56 | Re: Nested loops overpriced |
Previous Message | Oleg Bartunov | 2007-05-09 13:31:19 | Re: Cannot make GIN intarray index be used by the planner |