Re: I can't wait too much: Total runtime 432478.44 msec - Mailing list pgsql-performance

From Fernando Papa
Subject Re: I can't wait too much: Total runtime 432478.44 msec
Date
Msg-id F1DC5B511E2D1C499E5E20FC6D74160D03A04E61@exch2000.buehuergo.corp.claxson.com
Whole thread Raw
In response to I can't wait too much: Total runtime 432478.44 msec  ("Fernando Papa" <fpapa@claxson.com>)
List pgsql-performance
Err... you're right... one of us say the same thing when I show the
Volker mail...

-----Mensaje original-----
De: Manfred Koizar [mailto:mkoi-pg@aon.at]
Enviado el: lunes, 04 de agosto de 2003 12:17
Para: Fernando Papa
CC: Volker Helm; pgsql-performance@postgresql.org
Asunto: Re: [PERFORM] I can't wait too much: Total runtime 432478.44
msec


On Mon, 4 Aug 2003 12:02:46 -0300, "Fernando Papa" <fpapa@claxson.com>
wrote:
>     FROM
>     cont_contenido
>     ,juegos_config
>     ,cont_publicacion
>     ,(SELECT max(cp1.fecha_publicacion) as max_pub
--change here
>                      FROM cont_publicacion cp1) a     --change here

But this calculates the global maximum, not per id_instalacion,
id_contenido, and generar_vainilla as in

>         AND cont_publicacion.fecha_publicacion = (SELECT
max(cp1.fecha_publicacion)
>                          FROM cont_publicacion cp1
>                          WHERE cp1.id_instalacion =
cont_publicacion.id_instalacion
>                            AND cp1.id_contenido =
cont_publicacion.id_contenido
>                            AND cp1.generar_vainilla =
cont_publicacion.generar_vainilla)

Servus
 Manfred

pgsql-performance by date:

Previous
From: Scott Cain
Date:
Subject: Re: EXTERNAL storage and substring on long strings
Next
From: Tom Lane
Date:
Subject: Re: [SQL] EXTERNAL storage and substring on long strings