Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id C939A9FB43A for ; Wed, 31 Jan 2007 21:30:01 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 84160-01 for ; Wed, 31 Jan 2007 21:29:35 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.189]) by postgresql.org (Postfix) with ESMTP id E26579FB404 for ; Wed, 31 Jan 2007 21:29:57 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id x4so750012nfb for ; Wed, 31 Jan 2007 17:29:56 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=uAIKJ3nX9IZNevQmpafaAGlKMKfHjMT6m3j1C1W3lflWJiGnv3Jrw1I09AKXillfNKzmIdr+Yj1r/mqivb9Z8FAsqGDeWt2aVAZqVkrLpCO2ywILwT+zbegCLJi+Qg61Vn1ICzPw42inzYqs9N0b9lO3qkAa43SCz+CwroC6ATc= Received: by 10.49.27.11 with SMTP id e11mr1828699nfj.1170293395865; Wed, 31 Jan 2007 17:29:55 -0800 (PST) Received: by 10.48.210.4 with HTTP; Wed, 31 Jan 2007 17:29:55 -0800 (PST) Message-ID: <81961ff50701311729v1327d5bdha1de923303ea0641@mail.gmail.com> Date: Wed, 31 Jan 2007 20:29:55 -0500 From: "Chad Wagner" To: "=?ISO-8859-1?Q?Sidar_L=F3pez_Cruz?=" Subject: Re: Very slow queries Cc: pgsql-performance@postgresql.org, tallen@blackducksoftware.com In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_22721_15408997.1170293395753" References: <45C0A88B.2060409@blackducksoftware.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/452 X-Sequence-Number: 23053 ------=_Part_22721_15408997.1170293395753 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 1/31/07, Sidar L=F3pez Cruz wrote: > > Executing these query take: > Query returned successfully: 290 rows affected, 2542387 ms execution time= . > I think that's too many time I would post the plans that you are getting, otherwise just mentioning the execution time is not very helpful. Also, yet another syntax is the UPDATE foo... FROM tab1, tab2... syntax. http://www.postgresql.org/docs/8.2/static/sql-update.html In any case, I thought you mentioned this was a one off query? --=20 Chad http://www.postgresqlforums.com/ ------=_Part_22721_15408997.1170293395753 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 1/31/07, Sidar L=F3pez Cruz <sidarlopez@hotmail.com> wrote:
Executing these query take:
Query returned successfully: 290 rows affect= ed, 2542387 ms execution time.
I think that's too many time

I would post the plans that you are getting, otherwise just me= ntioning the execution time is not very helpful.  Also, yet another sy= ntax is the UPDATE foo... FROM tab1, tab2... syntax.

http://www.postgresql.org/docs/8.2/static/sql-update.html


In any case, I thought you mentioned this was a one off query?=  =20



--
Chad
http://www.postgresqlforums.com/ ------=_Part_22721_15408997.1170293395753--