Quick Links

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
Views:	Whole Thread \| Raw Message \| Download mbox \| Resend email
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

RES: select on 1milion register = 6s at 2007-07-28 20:12:10 from Bruno Rodrigues Siqueira

RES: RES: select on 1milion register = 6s at 2007-07-28 22:38:54 from Bruno Rodrigues Siqueira
Re: RES: select on 1milion register = 6s at 2007-07-29 16:35:37 from Decibel!

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