Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W843Z-0004Qq-3F for pgsql-performance@arkaria.postgresql.org; Tue, 28 Jan 2014 08:30:05 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1W843Y-0002By-Jd for pgsql-performance@arkaria.postgresql.org; Tue, 28 Jan 2014 08:30:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W843X-0002AP-6i for pgsql-performance@postgresql.org; Tue, 28 Jan 2014 08:30:03 +0000 Received: from new1-smtp.messagingengine.com ([66.111.4.221]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W843O-0007f8-FA for pgsql-performance@postgresql.org; Tue, 28 Jan 2014 08:30:02 +0000 Received: from compute4.internal (compute4.nyi.mail.srv.osa [10.202.2.44]) by gateway1.nyi.mail.srv.osa (Postfix) with ESMTP id 4F504409 for ; Tue, 28 Jan 2014 03:29:52 -0500 (EST) Received: from web6 ([10.202.2.216]) by compute4.internal (MEProxy); Tue, 28 Jan 2014 03:29:52 -0500 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=iancu.ch; h= message-id:from:to:mime-version:content-transfer-encoding :content-type:in-reply-to:references:subject:date; s=mesmtp; bh= vkVsKO9T00pHTgK53xDOOQrtbFA=; b=sFpBN6V90ixRjttWVuzX/Ffa28VQzF22 dL1JGgZpvHfHqfAU0+VswYwoAaO6PiA2Y6ed2Qg4dlpH8/sBUauChMozkknO9bum x6CMe1HzOyMhNvS28o0Hj8iELoaLdcPPngSpBdHjdfptIEtU4OJeZsaob4FgdJv3 nBErJh7yuqw= DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d= messagingengine.com; h=message-id:from:to:mime-version :content-transfer-encoding:content-type:in-reply-to:references :subject:date; s=smtpout; bh=vkVsKO9T00pHTgK53xDOOQrtbFA=; b=ACo EFK9WpHq8iH2/tN8+9iRPnll56rIFcTga6ReGiRVmzvATTnrhBgmiAd9GALDxPg9 xTg1YH4moDFeQ5UyJO62csg5kOjrqw3Z3fhbYytPwTgVnCSF2/C4uzCna/ON1FgY HZp0fRLUJd8lKaukklIRcaKD5o3en71JYw3YyFKQ= Received: by web6.nyi.mail.srv.osa (Postfix, from userid 99) id 0758D303B2A; Tue, 28 Jan 2014 03:29:52 -0500 (EST) Message-Id: <1390897791.7626.76183993.09BEE19B@webmail.messagingengine.com> X-Sasl-Enc: q6sYpsa//OfX8FbjYhXZ5AKZ+a2sYwDediDEwk+WAEvc 1390897791 From: Stelian Iancu To: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain X-Mailer: MessagingEngine.com Webmail Interface - ajax-1b692d69 In-Reply-To: <52E6B6CB.4060906@archidevsys.co.nz> 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> <52E6B6CB.4060906@archidevsys.co.nz> Subject: Re: Slow query (wrong index used maybe) Date: Tue, 28 Jan 2014 00:29:51 -0800 X-Pg-Spam-Score: -2.7 (--) 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 Mon, Jan 27, 2014, at 11:43, Gavin Flower wrote: > 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? > > I cannot reply for Bob, but we're on Debian 7. > 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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance