| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2007-02-01 01:32:20 | Re: Slow update |
| Previous Message | Abu Mushayeed | 2007-02-01 00:57:38 | Slow update |