Re: Optimizing `WHERE x IN` query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Optimizing `WHERE x IN` query
From: Michael Lewis <mlewis@xxxxxxxxxxx>
Date: Thu, 11 Jul 2019 16:24:33 -0600
Cc: "pgsql-performance@xxxxxxxxxxxxxxxxxxxx" <pgsql-performance@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <DM5PR18MB105110A24BA55ACD72894026DFF30@DM5PR18MB1051.namprd18.prod.outlook.com>
References: <DM5PR18MB1051CD296F9F94AE0D67FD84DFF70@DM5PR18MB1051.namprd18.prod.outlook.com> <86b8a755-2fa4-f7c2-8b0b-3290773feb97@gmx.net> <687daa64-4fc4-466d-25ed-1a664c9cdf98@rudder.io> <DM5PR18MB105110A24BA55ACD72894026DFF30@DM5PR18MB1051.namprd18.prod.outlook.com>

Did you create a GIN index on subscriptions column to support the && operator?

References:
- Optimizing `WHERE x IN` query
  - From: Omar Roth
- Re: Optimizing `WHERE x IN` query
  - From: Thomas Kellerer
- Re: Optimizing `WHERE x IN` query
  - From: Nicolas Charles
- Re: Optimizing `WHERE x IN` query
  - From: Omar Roth

Prev by Date: Re: Optimizing `WHERE x IN` query
Next by Date: Filtering on an enum field in a foreign table
Previous by thread: Re: Optimizing `WHERE x IN` query
Next by thread: Filtering on an enum field in a foreign table
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux