Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M51230=pgsql-performance-ar@postgresql.org>)
 id 1WGyqt-0007BE-ST
 for pgsql-performance@arkaria.postgresql.org; Fri, 21 Feb 2014 22:45:52 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M51230=pgsql-performance-ar@postgresql.org>)
 id 1WGyqt-0006jR-16
 for pgsql-performance@arkaria.postgresql.org; Fri, 21 Feb 2014 22:45:51 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <peter.geoghegan86@gmail.com>) id 1WGyqr-0006jK-MS
 for pgsql-performance@postgresql.org; Fri, 21 Feb 2014 22:45:49 +0000
Received: from mail-pd0-x232.google.com ([2607:f8b0:400e:c02::232])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <peter.geoghegan86@gmail.com>) id 1WGyqM-0005mI-KJ
 for pgsql-performance@postgresql.org; Fri, 21 Feb 2014 22:45:49 +0000
Received: by mail-pd0-f178.google.com with SMTP id fp1so3865740pdb.23
 for <pgsql-performance@postgresql.org>; Fri, 21 Feb 2014 14:45:17 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=mime-version:in-reply-to:references:date:message-id:subject:from:to
 :cc:content-type;
 bh=o/hGRSNYy34WNa7cC4L/WcbWev2MD1/EBMJ7/knSQ0k=;
 b=rXIGYmzrYMzbj11x9drpLUfa57Vvb9P2ks51Ct5+wmdUQvTkPUwhbdolzMBCjFbmqM
 pgCXkDzk7gmYV7Kpq/Tea69Yuxn+FXpyj7qZptpgReLZmFhtQ61wtvisxHukUvBjkIiC
 sdK1hWyKvz41AxsSno6aWC58xk8j6nt/HNiDyE3d80wymdLuL4/RYPPvnDVKBv/M5bEU
 8ObYXTrD10PqAOi6bhhKI8xw8JEgp4qR+Md2JOdMe67Ywsh8Imor6MgmKnCbAe31zkZP
 Y6Xz2kByXPSJrOBI6TCDKF6mhBdVyhg/+6z3svbsy69NS42H6Exocz5lk3OwgzRrSBzR
 JZ2w==
MIME-Version: 1.0
X-Received: by 10.67.23.135 with SMTP id ia7mr11638119pad.5.1393022717636;
 Fri, 21 Feb 2014 14:45:17 -0800 (PST)
Received: by 10.68.57.70 with HTTP; Fri, 21 Feb 2014 14:45:17 -0800 (PST)
In-Reply-To: 
 <CAAS3ty+CzbQ1F2Mgf=EahuU=xJ-=B_=L=Bx3pk-MO9yzO84jhA@mail.gmail.com>
References: 
 <CAAS3ty+GD9xfh4M4OiGLSQxHRyQGUS1VUaofdxqCn0A=_z4rRw@mail.gmail.com>
 <5576.1393009497@sss.pgh.pa.us> <19686.1393020721@sss.pgh.pa.us>
 <CAAS3ty+CzbQ1F2Mgf=EahuU=xJ-=B_=L=Bx3pk-MO9yzO84jhA@mail.gmail.com>
Date: Fri, 21 Feb 2014 14:45:17 -0800
Message-ID: 
 <CAEYLb_Wh55DiuYUtUEC1utpv1bbc4f6MbcSCevg3A2wxjD3b7Q@mail.gmail.com>
Subject: Re: Lack of index usage when doing array casts
From: Peter Geoghegan <peter.geoghegan86@gmail.com>
To: Alexey Klyukin <alexk@hintbits.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-performance@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
X-Pg-Spam-Score: -1.8 (-)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

On Fri, Feb 21, 2014 at 2:37 PM, Alexey Klyukin <alexk@hintbits.com> wrote:
> Hopefully I'll be able to give it a spin next week and will let you know
> whether the patch improved the execution plans in our environment.

9.3.3 is out this week; you'll have to wait a few months for this if
you're using standard packages, I'm afraid.


-- 
Regards,
Peter Geoghegan


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance