Skip site navigation (1)
Skip section navigation (2)
On 1/31/07, Sidar López Cruz <sidarlopez(at)hotmail(dot)com> wrote:
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/
Peripheral Links
Header And Logo
|
Site Navigation
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: Wed, 31 Jan 2007 20:29:55 -0500
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/
- References:
- Re: Very slow queries
- From: Ted Allen
- Re: Very slow queries
- From: Sidar López Cruz
- Re: Very slow queries
- Prev by Date: Slow update
- Next by Date: Re: Slow update
- Previous by thread: Re: Very slow queries
- Next by thread: Slow update
- Indexes: