Postgres Pro
Downloads
Home   >   mailing lists

Re: integer[] indexing. - Mailing list pgsql-performance

From Pierre-Frédéric Caillaud
Subject Re: integer[] indexing.
Date
Msg-id opsfjonlc0cq72hf@musicbox
Whole thread Raw
In response to integer[] indexing.  (Dawid Kuroczko <qnex42@gmail.com>)
List pgsql-performance
Tree view 
    disclaimer : brainless proposition

(SELECT * FROM table WHERE (icount(ids) <= 1 AND ids[1] = 33)
UNION ALL
(SELECT * FROM table WHERE (icount(ids) > 1 AND ids && '{33}'));

pgsql-performance by date:

Previous
From: Dawid Kuroczko
Date:
Subject: integer[] indexing.
Next
From: Pierre-Frédéric Caillaud
Date:
Subject: Re: sequential scan on select distinct