Postgres Pro
Downloads
Home   >   mailing lists

don't use GIN index, when i use =any - Mailing list pgsql-general

From Laczi József
Subject don't use GIN index, when i use =any
Date
Msg-id 49104B91.7050009@ritek.hu
Whole thread Raw
List pgsql-general
Tree view 
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?

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Hot standby stops after a few days of inactivity (i.e. no new WAL)
Next
From: "Merlin Moncure"
Date:
Subject: Re: Hot standby stops after a few days of inactivity (i.e. no new WAL)