Re: [PERFORM] select with max functions

Поиск
Список
Период
Сортировка
От Gerardo Herzig
Тема Re: [PERFORM] select with max functions
Дата
Msg-id 1990398729.67887.1506951911360.JavaMail.zimbra@fmed.uba.ar
обсуждение исходный текст
Ответ на Re: [PERFORM] select with max functions  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Ответы Re: [PERFORM] select with max functions  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Mariel Cherkassky
Дата:
Сообщение: Re: [PERFORM] select with max functions
Следующее
От: Mariel Cherkassky
Дата:
Сообщение: Re: [PERFORM] select with max functions