Postgres Pro
Downloads
Home   >   mailing lists

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

From Mendola Gaetano
Subject Re: I can't wait too much: Total runtime 432478.44 msec
Date
Msg-id 005701c358e1$e4b52af0$10d4a8c0@mm.eutelsat.org
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
Tree view 
From: ""Fernando Papa"" <fpapa@claxson.com>

> 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 (
upper(generar_Vainilla) )



Regards
Gaetano Mendola

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: I can't wait too much: Total runtime 432478.44 msec
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Odd explain estimate