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 performance when > I used the max :

[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