Re: [PERFORM] select with max functions

2017-10-03 Thread Mark Kirkwood
On 03/10/17 04:29, Tom Lane wrote: Mariel Cherkassky writes: explain analyze SELECT Ma.User_Id, COUNT(*) COUNT FROM Manuim Ma WHERE Ma.Bb_Open_Date = (SELECT Bb_Open_Date

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
ws) 2017-10-02 16:45 GMT+03:00 Gerardo Herzig : > > > - Mensaje original - > > De: "Mariel Cherkassky" > > Para: "Andreas Kretschmer" > > CC: pgsql-performance@postgresql.org > > Enviados: Lunes, 2 de Octubre 2017 10:25:19 > &g

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

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

Re: [PERFORM] select with max functions

2017-10-01 Thread Andreas Kretschmer
Am 01.10.2017 um 14:41 schrieb Mariel Cherkassky: Hi, I need to use the max function in my query. I had very bad performance when I used the max : SELECT Ma.User_Id, COUNT(*) COUNT FROM Manuim Ma WHERE Ma.Bb_Open_Date =

Re: [PERFORM] select with max functions

2017-10-01 Thread Gerardo Herzig
- Mensaje original - > De: "Mariel Cherkassky" > Para: pgsql-performance@postgresql.org > Enviados: Domingo, 1 de Octubre 2017 9:41:37 > Asunto: [PERFORM] select with max functions > > Hi, > I need to use the max function in my query. I had very bad pe

[PERFORM] select with max functions

2017-10-01 Thread Mariel Cherkassky
Hi, I need to use the max function in my query. I had very bad performance when I used the max : SELECT Ma.User_Id, COUNT(*) COUNT FROM Manuim Ma WHERE Ma.Bb_Open_Date = (SELECT max(Bb_Open_Da