| From: | "J(dot)Fernando Moyano" <txinete(at)wanadoo(dot)es> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | very very slow ..... |
| Date: | 2001-04-02 02:44:00 |
| Message-ID: | 01040204440001.01615@txino.mikasa.eh |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Masto | 2001-04-02 03:17:18 | Re: Trigger Function and Html Output |
| Previous Message | Christopher Kings-Lynne | 2001-04-02 01:31:43 | RE: [HACKERS] Error in the date field (with NULL value...).Thanks! |