Received: from txino.mikasa.eh (94-ZARA-X10.libre.retevision.es [62.82.227.94]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f32KeeK44419 for ; Mon, 2 Apr 2001 16:40:40 -0400 (EDT) (envelope-from txino@wanadoo.es) Received: by txino.mikasa.eh (Postfix, from userid 502) id 2370175CE1; Mon, 2 Apr 2001 04:44:01 +0200 (CEST) From: "J.Fernando Moyano" Date: Mon, 2 Apr 2001 04:44:00 +0200 X-Mailer: KMail [version 1.1.99] Content-Type: text/plain; charset="iso-8859-1" To: pgsql-sql@postgresql.org Subject: very very slow ..... MIME-Version: 1.0 Message-Id: <01040204440001.01615@txino.mikasa.eh> Content-Transfer-Encoding: 8bit X-Archive-Number: 200104/15 X-Sequence-Number: 2354 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