Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W7s5e-00024A-JJ for pgsql-performance@arkaria.postgresql.org; Mon, 27 Jan 2014 19:43:26 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1W7s5d-00067y-8W for pgsql-performance@arkaria.postgresql.org; Mon, 27 Jan 2014 19:43:25 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W7s5c-00067r-11 for pgsql-performance@postgresql.org; Mon, 27 Jan 2014 19:43:24 +0000 Received: from mbx.knossos.net.nz ([202.160.48.10]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W7s5R-0000It-Ny for pgsql-performance@postgresql.org; Mon, 27 Jan 2014 19:43:20 +0000 Received: from [10.1.1.3] ([121.99.254.45]) (authenticated bits=0) by mbx.knossos.net.nz (8.14.4/8.14.4) with ESMTP id s0RJh8RL026043 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT); Tue, 28 Jan 2014 08:43:08 +1300 Message-ID: <52E6B6CB.4060906@archidevsys.co.nz> Date: Tue, 28 Jan 2014 08:43:07 +1300 From: Gavin Flower Organization: ArchiDevSys User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.2.0 MIME-Version: 1.0 To: bobJobS , pgsql-performance@postgresql.org Subject: Re: Slow query (wrong index used maybe) References: <1390833860.7369.75825537.0CAF7BA8@webmail.messagingengine.com> <2631.1390835184@sss.pgh.pa.us> <1390844278.5638.75903621.2E4ABB56@webmail.messagingengine.com> <1390849849986-5789045.post@n5.nabble.com> In-Reply-To: <1390849849986-5789045.post@n5.nabble.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -0.0 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On 28/01/14 08:10, bobJobS wrote: > My developers have had the same issue. > > Postgres 9.2.3 on Linux 5.6. > The latest Linux kernel is 3.13 (https://www.kernel.org), so I assume 5.6 is a distribution version. So which distribution of Linux are you using? Cheers, Gavin -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance