Обсуждение: very very slow .....

I have a system called "eisenor" running in 6.5 and it runs very well.
I'have installed 7.0.2 at home and i'm working with it and "eisenor".

Tables are created without problems, and functions too (except some minor 
changes related to date/time).

Very complex queries execute without error ... but some of them are really 
SLOOOooooooOOOW !!

The execution time of certain queries is 20 or 30 times longer in 7.0.2 that 
6.5. (20 or 30 seconds where before it was 1 or 2 seconds !!!)

The table structure is the same, with same indexes, constrains,etc... ¿what 
happens??? ¿ideas??? iI it a 7.0.2 "feature"? Must i try 7.2 ?

Thanks !!

-- 
Fernando Moyano

Frase del día:
--------------
Real programmers do: copy con program.exe

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

"J.Fernando Moyano" <txinete@wanadoo.es> writes:
> The execution time of certain queries is 20 or 30 times longer in 7.0.2 that 
> 6.5. (20 or 30 seconds where before it was 1 or 2 seconds !!!)

Have you done a VACUUM ANALYZE?

Other than that, there's no generic advice.  You'll need to provide some
details about the problem queries and the plans you get for them in 6.5
and 7.0.
        regards, tom lane

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