pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
very very slow .....
3+ messages / 2 participants
[nested] [flat]

* very very slow .....
@ 2001-04-02 02:44 J.Fernando Moyano <txinete@wanadoo.es>
  2001-04-03 01:19 ` Re: very very slow ..... Tom Lane <tgl@sss.pgh.pa.us>
  2001-04-06 00:36 ` Re: very very slow ..... 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-02 02:44 very very slow ..... J.Fernando Moyano <txinete@wanadoo.es>
@ 2001-04-03 01:19 ` Tom Lane <tgl@sss.pgh.pa.us>
  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-02 02:44 very very slow ..... J.Fernando Moyano <txinete@wanadoo.es>
@ 2001-04-06 00:36 ` 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