pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedvery very slow .....
3+ messages / 2 participants
[nested] [flat]
* very very slow .....
@ 2001-04-02 02:44 J.Fernando Moyano <txinete@wanadoo.es>
0 siblings, 2 replies; 3+ messages in thread
From: J.Fernando Moyano @ 2001-04-02 02:44 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: very very slow .....
@ 2001-04-03 01:19 Tom Lane <tgl@sss.pgh.pa.us>
parent: J.Fernando Moyano <txinete@wanadoo.es>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2001-04-03 01:19 UTC (permalink / raw)
To: J.Fernando Moyano <txinete@wanadoo.es>; +Cc: pgsql-sql
"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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: very very slow .....
@ 2001-04-06 00:36 J.Fernando Moyano <txinete@wanadoo.es>
parent: J.Fernando Moyano <txinete@wanadoo.es>
1 sibling, 0 replies; 3+ messages in thread
From: J.Fernando Moyano @ 2001-04-06 00:36 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2001-04-06 00:36 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-04-02 02:44 very very slow ..... J.Fernando Moyano <txinete@wanadoo.es>
2001-04-03 01:19 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-04-06 00:36 ` J.Fernando Moyano <txinete@wanadoo.es>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox