Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dz12S-0004VL-M3 for pgsql-performance@arkaria.postgresql.org; Mon, 02 Oct 2017 13:45:40 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dz12S-0006yI-2Q for pgsql-performance@arkaria.postgresql.org; Mon, 02 Oct 2017 13:45:40 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dz12R-0006xh-9E for pgsql-performance@postgresql.org; Mon, 02 Oct 2017 13:45:39 +0000 Received: from mail.fmed.uba.ar ([157.92.152.1] helo=azteca.fmed.uba.ar) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dz11t-0001a0-98 for pgsql-performance@postgresql.org; Mon, 02 Oct 2017 13:45:38 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by azteca.fmed.uba.ar (Postfix) with ESMTP id 206EC1F60FFD; Mon, 2 Oct 2017 10:45:12 -0300 (ART) Received: from azteca.fmed.uba.ar ([127.0.0.1]) by localhost (azteca.fmed.uba.ar [127.0.0.1]) (amavisd-new, port 10032) with ESMTP id hp33hAWju7jo; Mon, 2 Oct 2017 10:45:11 -0300 (ART) Received: from localhost (localhost.localdomain [127.0.0.1]) by azteca.fmed.uba.ar (Postfix) with ESMTP id 9472D1F61050; Mon, 2 Oct 2017 10:45:11 -0300 (ART) X-Virus-Scanned: amavisd-new at fmed.uba.ar Received: from azteca.fmed.uba.ar ([127.0.0.1]) by localhost (azteca.fmed.uba.ar [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id qUL2zSImmcM6; Mon, 2 Oct 2017 10:45:11 -0300 (ART) Received: from azteca.fmed.uba.ar (azteca.fmed.uba.ar [157.92.152.1]) by azteca.fmed.uba.ar (Postfix) with ESMTP id 73E481F60FFD; Mon, 2 Oct 2017 10:45:11 -0300 (ART) Date: Mon, 2 Oct 2017 13:45:11 +0000 (UTC) From: Gerardo Herzig To: Mariel Cherkassky Cc: pgsql-performance@postgresql.org Message-ID: <1990398729.67887.1506951911360.JavaMail.zimbra@fmed.uba.ar> In-Reply-To: References: <0970df65-602e-724d-2c39-e4695ae48bb6@a-kretschmer.de> Subject: Re: select with max functions MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Originating-IP: [157.92.152.69] X-Mailer: Zimbra 8.0.9_GA_6191 (ZimbraWebClient - FF52 (Linux)/8.0.9_GA_6191) Thread-Topic: select with max functions Thread-Index: bSJXEJG+3OYe43fCqhLk0mRqHEc16w== 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 ----- Mensaje original ----- > De: "Mariel Cherkassky" > Para: "Andreas Kretschmer" > CC: pgsql-performance@postgresql.org > Enviados: Lunes, 2 de Octubre 2017 10:25:19 > Asunto: Re: [PERFORM] select with max functions > > Andreas I tried to rewrite it with the function rank() but I failed. The > query you wrote isnt the same as what I search. Moreover, I cant use > explain analyze because it is taking to much time to run and I'm getting > timeout.. > > 2017-10-01 21:48 GMT+03:00 Andreas Kretschmer : Do a "set statement_timeout TO 0" prior to "explain analyze" -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance