Home > mailing lists

Use index with x = ANY(array_column) expression - Mailing list pgsql-general

From	Havasvölgyi Ottó
Subject	Use index with x = ANY(array_column) expression
Date	June 9, 2018 01:01:47
Msg-id	CAOryeA2DHD_ZiuVtgzmBoBupjHHTPUUCW4_Ut9PbyjGM2ts=2Q@mail.gmail.com Whole thread Raw
List	pgsql-general

Hi all,

Is there a way to speed up ANY-based array element search with some kind of index?

I mean this:

WHERE <parameter> = ANY(<array_column>)

Or is GIN index the only option with the @> operator?

WHERE <array_column> @> ARRAY[<parameter>]

Thank you,

Otto

From: Jeremy Finzel
Date: 09 June 2018, 00:30:33
Subject: Re: ERROR: found multixact from before relminmxid

From: Steve Atkins
Date: 09 June 2018, 02:26:12
Subject: Re: Performance problem postgresql 9.5