From: | "Bruno Rodrigues Siqueira" <bruno(at)ravnus(dot)com> |
---|---|
To: | "'Ragnar'" <gnari(at)hive(dot)is> |
Cc: | <pgsql-performance(at)postgresql(dot)org> |
Subject: | RES: RES: select on 1milion register = 6s |
Date: | 2007-07-28 22:38:54 |
Message-ID: | 002a01c7d168$16b4a550$e900a8c0@brunolaptop |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Rodrigues Siqueira | 2007-07-28 22:40:48 | RES: select on 1milion register = 6s |
Previous Message | Ragnar | 2007-07-28 22:36:16 | Re: RES: select on 1milion register = 6s |