Re: very very slow .....

From: "J(dot)Fernando Moyano" <txinete(at)wanadoo(dot)es>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: very very slow .....
Date: 2001-04-06 00:36:26
Message-ID: 01040602362600.01608@txino.mikasa.eh
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

El Jueves 05 Abril 2001 04:10, escribiste:
>
> You would probably have better luck if you cast the date restriction
> as a range, for example
>
> where fecha_factura >= '2001-03-01'
> and fecha_factura < '2001-04-01'

True !!!!
It runs 10 times faster !!!!!!!
You are a genius !!!! ;-))

Thanks !!

--
Fernando Moyano

Frase del día:
--------------
Yo antes era vanidoso, pero me cure, y ahora soy perfecto! O:-)

(*) SymeX ==> http://symex.lantik.com
(*) WDBIL ==> http://wdbil.sourceforge.net
(*) Informate sobre LINUX en http://www.linux.org

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message guard 2001-04-06 02:52:30 get all online user?
Previous Message Ian Harding 2001-04-05 23:19:02 Re: Index on View ?