rows)
-Mensaje original-
De: Christopher Browne [mailto:[EMAIL PROTECTED]
Enviado el: viernes, 01 de agosto de 2003 18:27
Para: Fernando Papa
CC: [EMAIL PROTECTED]
Asunto: Re: [PERFORM] I can't wait too much: Total runtime 432478.44 msec
I'd point at the following as being a sterling
)
-Mensaje original-
De: Josh Berkus [mailto:[EMAIL PROTECTED]
Enviado el: viernes, 01 de agosto de 2003 18:32
Para: Christopher Browne; Fernando Papa
CC: [EMAIL PROTECTED]
Asunto: Re: [PERFORM] I can't wait too much: Total runtime 432478.44
msec
Fernando,
AND cont_publicacion.fecha_publicacion
I create the index, but doesn't help too much:
QUERY
PLAN
on cp1 (cost=0.00..12.48 rows=448
width=8) (actual time=0.05..11.62 rows=448 loops=16)Total runtime:
2250.92 msec(20 rows)
The
problem was the subquery, no doubt.
-Mensaje original-De: Volker Helm
[mailto:[EMAIL PROTECTED] Enviado el: lunes, 04 de agosto de 2003
11:45Para: Ferna
Err... you're right... one of us say the same thing when I show the
Volker mail...
-Mensaje original-
De: Manfred Koizar [mailto:[EMAIL PROTECTED]
Enviado el: lunes, 04 de agosto de 2003 12:17
Para: Fernando Papa
CC: Volker Helm; [EMAIL PROTECTED]
Asunto: Re: [PERFORM] I can't wait too
From: Fernando Papa [EMAIL PROTECTED]
AND upper(cont_publicacion.generar_Vainilla) = 'S'
Filter: ((upper((generar_vainilla)::text) = 'S'::text) AND
(fecha_publicacion = (subplan)))
using a functional index on this field should help
create index idx_generar_vainilla_ci on cont_publicacion (
Title: Mensaje
Hi
all!
Really I don't know
what happened with this query. I'm running PG 7.3.1 on solaris, vaccumed (full)
every nigth.
The cardinality of
each table was:
cont_contenido: 97 rows
juegos_config: 40 rows
cont_publicacion: 446 rows
not huge
tables...
however, this query
I'd point at the following as being a sterling candidate for being a
cause of this being slow...
AND cont_publicacion.fecha_publicacion = (SELECT max(cp1.fecha_publicacion)
FROM cont_publicacion cp1
WHERE cp1.id_instalacion =
Fernando,
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