Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Sat, 28 Jul 2007 22:36:16 +0000
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
- Follow-Ups:
- Re: RES: select on 1milion register = 6s
- From: Decibel!
- RES: RES: select on 1milion register = 6s
- From: Bruno Rodrigues Siqueira
- Re: RES: select on 1milion register = 6s
- References:
- RES: select on 1milion register = 6s
- From: Bruno Rodrigues Siqueira
- RES: select on 1milion register = 6s
- Prev by Date: Re: Slow query with backwards index scan
- Next by Date: RES: RES: select on 1milion register = 6s
- Previous by thread: RES: select on 1milion register = 6s
- Next by thread: RES: RES: select on 1milion register = 6s
- Indexes: