Re: [PERFORM] select with max functions

2017-10-02 Thread Tom Lane
Mariel Cherkassky writes: > explain analyze SELECT Ma.User_Id, > COUNT(*) COUNT >FROM Manuim Ma >WHERE Ma.Bb_Open_Date = > (SELECT Bb_Open_Date >FROM Manuim Man >

Re: [PERFORM] select with max functions

2017-10-02 Thread Mariel Cherkassky
explain analyze SELECT Ma.User_Id, COUNT(*) COUNT FROM Manuim Ma WHERE Ma.Bb_Open_Date = (SELECT Bb_Open_Date FROM Manuim Man WHERE Ma

Re: [PERFORM] select with max functions

2017-10-02 Thread Gerardo Herzig
- 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. Th

Re: [PERFORM] select with max functions

2017-10-02 Thread Mariel Cherkassky
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 : > > > Am 01.10.2017 um 1