Re: [PERFORM] select with max functions - Mailing list pgsql-performance

From Gerardo Herzig
Subject Re: [PERFORM] select with max functions
Date
Msg-id 1990398729.67887.1506951911360.JavaMail.zimbra@fmed.uba.ar
Whole thread Raw
In response to Re: [PERFORM] select with max functions  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Responses Re: [PERFORM] select with max functions
List pgsql-performance

----- Mensaje original -----
> De: "Mariel Cherkassky" <mariel.cherkassky@gmail.com>
> Para: "Andreas Kretschmer" <andreas@a-kretschmer.de>
> 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 <andreas@a-kretschmer.de>:

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

pgsql-performance by date:

Previous
From: Mariel Cherkassky
Date:
Subject: Re: [PERFORM] select with max functions
Next
From: Mariel Cherkassky
Date:
Subject: Re: [PERFORM] select with max functions