Re: I can't wait too much: Total runtime 432478.44 msec

From: "Mendola Gaetano" <mendola(at)bigfoot(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Cc: "\"Fernando Papa\"" <fpapa(at)claxson(dot)com>
Subject: Re: I can't wait too much: Total runtime 432478.44 msec
Date: 2003-08-02 10:36:12
Message-ID: 005701c358e1$e4b52af0$10d4a8c0@mm.eutelsat.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

From: ""Fernando Papa"" <fpapa(at)claxson(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2003-08-02 15:59:54 Re: Odd explain estimate
Previous Message Ron Johnson 2003-08-01 23:56:33 Re: Domains (Was [PERFORM] Views With Unions)