Skip site navigation (1) Skip section navigation (2)

Re: Very slow queries

From: "Chad Wagner" <chad(dot)wagner(at)gmail(dot)com>
To: Sidar López Cruz <sidarlopez(at)hotmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org, tallen(at)blackducksoftware(dot)com
Subject: Re: Very slow queries
Date: 2007-02-01 01:29:55
Message-ID: 81961ff50701311729v1327d5bdha1de923303ea0641@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On 1/31/07, Sidar López Cruz <sidarlopez(at)hotmail(dot)com> 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?



-- 
Chad
http://www.postgresqlforums.com/

In response to

pgsql-performance by date

Next:From: Tomas VondraDate: 2007-02-01 01:32:20
Subject: Re: Slow update
Previous:From: Abu MushayeedDate: 2007-02-01 00:57:38
Subject: Slow update

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group