Please reply-all so others can learn and contribute.
On Sun, Jul 29, 2007 at 09:38:12PM -0700, Craig James wrote:
> Decibel! wrote:
> >It's unlikely that it's going to be faster to index scan 2.3M rows than
> >to sequential scan them. Try setting enable_seqscan=false and see if it
> >is or not.
>
On Sun, Jul 29, 2007 at 01:44:23PM -0300, Bruno Rodrigues Siqueira wrote:
> EXPLAIN
> ANALYZE
> select
>to_char(data_encerramento,'mm/') as opcoes_mes,
>to_char(data_encerramento,'-mm') as ordem from detalhamento_bas
> where
>
> data_encerramento >= '01/12/2006' and
Strange!!! Why does the index not works?
All my querys doesn't work with range dates I don't know what to do...
Please, help!
Bruno
-Mensagem original-
De: Decibel! [mailto:[EMAIL PROTECTED]
Enviada em: domingo, 29 de julho de 2007 13:36
Para: Ragnar
Cc: Bruno Rodrigues Siqu
On Sat, Jul 28, 2007 at 10:36:16PM +, Ragnar wrote:
> On lau, 2007-07-28 at 17:12 -0300, Bruno Rodrigues Siqueira wrote:
>
> > where
> >
> > to_char( data_encerramento ,'-mm')
> > between '2006-12' and '2007-01'
>
> assuming data_encerramento is a date column, try:
> WHERE data_encer
Yes, i do.
-Mensagem original-
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Em nome de Hervé Piedvache
Enviada em: sábado, 28 de julho de 2007 16:57
Para: pgsql-performance@postgresql.org
Cc: Bruno Rodrigues Siqueira
Assunto: Re: [PERFORM] select on 1milion register = 6s
Do you hav
Yes.
Look this... and please, tell me if you can help me...
Thanks
Query
EXPLAIN
ANALYZE
select
to_char(data_encerramento,'mm/') as opcoes_mes,
to_char(data_encerramento,'-mm') as ordem from detalhamento_bas
where
to_char( data_encerramento ,'-mm')
between '2
: [PERFORM] select on 1milion register = 6s
On lau, 2007-07-28 at 17:12 -0300, Bruno Rodrigues Siqueira wrote:
> where
>
> to_char( data_encerramento ,'-mm')
> between '2006-12' and '2007-01'
assuming data_encerramento is a date column, try:
WHE
On lau, 2007-07-28 at 17:12 -0300, Bruno Rodrigues Siqueira wrote:
> where
>
> to_char( data_encerramento ,'-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
-
Ok.
Query
EXPLAIN
ANALYZE
select
to_char(data_encerramento,'mm/') as opcoes_mes,
to_char(data_encerramento,'-mm') as ordem
from detalhamento_bas
where
to_char( data_encerramento ,'-mm')
between '2006-12' and '2007-01'
GROUP BY opcoes_mes, orde
