Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W7q3y-0004tK-7C for pgsql-performance@arkaria.postgresql.org; Mon, 27 Jan 2014 17:33:34 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1W7q3x-0001Au-IX for pgsql-performance@arkaria.postgresql.org; Mon, 27 Jan 2014 17:33:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W7q3w-00019D-0a for pgsql-performance@postgresql.org; Mon, 27 Jan 2014 17:33:32 +0000 Received: from new1-smtp.messagingengine.com ([66.111.4.221]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W7q3s-0008CJ-Uf for pgsql-performance@postgresql.org; Mon, 27 Jan 2014 17:33:31 +0000 Received: from compute5.internal (compute5.nyi.mail.srv.osa [10.202.2.45]) by gateway1.nyi.mail.srv.osa (Postfix) with ESMTP id 7E8467CE for ; Mon, 27 Jan 2014 12:33:27 -0500 (EST) Received: from web2 ([10.202.2.212]) by compute5.internal (MEProxy); Mon, 27 Jan 2014 12:33:27 -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= +zuZ8H+4QvFXKa02WxECtO64odE=; b=LDnYwFrDdp9RdBRaFyYrJ1rpTBb6PJ74 C8IvSe/Gks9u0qdvAlyuWwO8Xvc4S1xsUhnl7MHAaH5oHf6oHklmpUqStzcsI44G 6umoTHbt6vmxiG7FdjCSKs/UE4zEEbmfyaVNK/0yUU6e3jkDEA4yXJZtbuYxP/XC gn6Qx8NJwt8= 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=+zuZ8H+4QvFXKa02WxECtO64odE=; b=HRr C1R2+8WafnSG8T0W+uTAD2ZVg5WCbeBUhJiiomxYwhnHATk8dl/tjRs1sXdo6B6p Huc87ge+Ph0UFIrEMNe1pVHt86xe3tGdClFvPHzczfX54UuyaJojUPnVmmGh21op RkHII/uGkJoB3l8za/EO/PZ0950EQhl4t7jMBlhg= Received: by web2.nyi.mail.srv.osa (Postfix, from userid 99) id 3DB95540101; Mon, 27 Jan 2014 12:33:27 -0500 (EST) Message-Id: <1390844007.4503.75903157.396237B6@webmail.messagingengine.com> X-Sasl-Enc: IAm6mQ9rEm+hAheA+2hFBkgWBx7no9524S8iMeLSiJfl 1390844007 From: Stelian Iancu To: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="ISO-8859-1" X-Mailer: MessagingEngine.com Webmail Interface - ajax-aec78a11 In-Reply-To: <1390843257.23746.YahooMailNeo@web164806.mail.gq1.yahoo.com> References: <1390833860.7369.75825537.0CAF7BA8@webmail.messagingengine.com> <1390843257.23746.YahooMailNeo@web164806.mail.gq1.yahoo.com> Subject: Re: Slow query (wrong index used maybe) Date: Mon, 27 Jan 2014 09:33:27 -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 9:20, salah jubeh wrote: > Hello Stelian,=A0 >=20 Hello, > Have you tried to use func_table module?, I think it will help you to eli= minate all the joins. No, I haven't. I can have a look later, thanks. >=20 > Regards >=20 =20 >=20 --=20 Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance