| From: | Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar> |
|---|---|
| To: | Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: select with max functions |
| Date: | 2017-10-02 13:45:11 |
| Message-ID: | 1990398729.67887.1506951911360.JavaMail.zimbra@fmed.uba.ar |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
----- Mensaje original -----
> De: "Mariel Cherkassky" <mariel(dot)cherkassky(at)gmail(dot)com>
> Para: "Andreas Kretschmer" <andreas(at)a-kretschmer(dot)de>
> CC: pgsql-performance(at)postgresql(dot)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(at)a-kretschmer(dot)de>:
Do a "set statement_timeout TO 0" prior to "explain analyze"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mariel Cherkassky | 2017-10-02 14:45:36 | Re: select with max functions |
| Previous Message | Mariel Cherkassky | 2017-10-02 13:25:19 | Re: select with max functions |