Postgres Pro
Downloads
Home   >   mailing lists

Re: Very slow queries - Mailing list pgsql-performance

From Chad Wagner
Subject Re: Very slow queries
Date
Msg-id 81961ff50701311729v1327d5bdha1de923303ea0641@mail.gmail.com
Whole thread Raw
In response to Re: Very slow queries  (Sidar López Cruz <sidarlopez@hotmail.com>)
List pgsql-performance
Tree view
On 1/31/07, Sidar López Cruz <sidarlopez@hotmail.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/

pgsql-performance by date:

Previous
From: Abu Mushayeed
Date:
Subject: Slow update
Next
From: Tomas Vondra
Date:
Subject: Re: Slow update