Postgres Pro
Downloads
Home   >   mailing lists

Re: RES: select on 1milion register = 6s - Mailing list pgsql-performance

From Ragnar
Subject Re: RES: select on 1milion register = 6s
Date
Msg-id 1185662176.5778.314.camel@localhost.localdomain
Whole thread Raw
In response to RES: select on 1milion register = 6s  ("Bruno Rodrigues Siqueira" <bruno@ravnus.com>)
Responses RES: RES: select on 1milion register = 6s
Re: RES: select on 1milion register = 6s
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Tilmann Singer
Date:
Subject: Re: Slow query with backwards index scan
Next
From: "Bruno Rodrigues Siqueira"
Date:
Subject: RES: RES: select on 1milion register = 6s