Skip site navigation (1) Skip section navigation (2)

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

From: Ragnar <gnari(at)hive(dot)is>
To: Bruno Rodrigues Siqueira <bruno(at)ravnus(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: RES: select on 1milion register = 6s
Date: 2007-07-28 22:36:16
Message-ID: 1185662176.5778.314.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-performance
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



In response to

Responses

pgsql-performance by date

Next:From: Bruno Rodrigues SiqueiraDate: 2007-07-28 22:38:54
Subject: RES: RES: select on 1milion register = 6s
Previous:From: Tilmann SingerDate: 2007-07-28 20:54:50
Subject: Re: Slow query with backwards index scan

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group