RES: RES: select on 1milion register = 6s

Data_encerramento is a timestamp column

I will try your tip.
Thanks

-----Mensagem original-----
De: pgsql-performance-owner(at)postgresql(dot)org
[mailto:pgsql-performance-owner(at)postgresql(dot)org] Em nome de Ragnar
Enviada em: sábado, 28 de julho de 2007 19:36
Para: Bruno Rodrigues Siqueira
Cc: pgsql-performance(at)postgresql(dot)org
Assunto: Re: RES: [PERFORM] select on 1milion register = 6s

On lau, 2007-07-28 at 17:12 -0300, Bruno Rodrigues Siqueira wrote:

> where
>
> to_char( data_encerramento ,'yyyy-mm')
> between '2006-12' and '2007-01'

assuming data_encerramento is a date column, try:
WHERE data_encerramento between '2006-12-01' and '2007-01-31'

gnari

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend