don't use GIN index, when i use =any

From: Laczi József <laczi(dot)jozsef(at)ritek(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: don't use GIN index, when i use =any
Date: 2008-11-04 13:18:09
Message-ID: 49104B91.7050009@ritek.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all!

I have a problem. I have a field with type: bigint[], and I create a GIN
index on it but don't use the index when i use '=any'.
When I try it with '<@' operator, then use index. I don't understand why
doesn't work with '=any'?
Does anybody knows why doesn't work it?

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2008-11-04 13:37:52 Re: Hot standby stops after a few days of inactivity (i.e. no new WAL)
Previous Message Sathish Duraiswamy 2008-11-04 13:08:39 Re: [GENERAL] epqa; postgres performance optimizer support tool; opensource.