Received: from sss.pgh.pa.us ([216.151.103.158]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f331JDK75826 for ; Mon, 2 Apr 2001 21:19:13 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f331J7w24902; Mon, 2 Apr 2001 21:19:07 -0400 (EDT) To: "J.Fernando Moyano" cc: pgsql-sql@postgresql.org Subject: Re: very very slow ..... In-reply-to: <01040204440001.01615@txino.mikasa.eh> References: <01040204440001.01615@txino.mikasa.eh> Comments: In-reply-to "J.Fernando Moyano" message dated "Mon, 02 Apr 2001 04:44:00 +0200" Date: Mon, 02 Apr 2001 21:19:07 -0400 Message-ID: <24899.986260747@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200104/20 X-Sequence-Number: 2359 "J.Fernando Moyano" 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