From: mrblonde@locked.myftp.org
To: franco@akyasociados.com.ar
Cc: pgsql-sql@postgresql.org
Subject: Re: update from multiple rows
Date: Tue, 25 Jan 2005 00:32:20 +0100 (CET)
Message-ID: <20050124233220.6CA161C00085@mwinf1206.wanadoo.fr> (raw)
Thanks a lot.. That is what i searched.. In fact your query is very good for little changes, but i will have to use another method when updating all my rows because the performance is not very good alas.
My data set contains something like 40000 rows to update in 1+ million records and data_raw, data_sys are of type "real"... The complete update took 40 minutes on a 256Mo, athlon 2400, kernel 2.6 and with no charge during the execution of the query.
Is this normal ? The number of columns of the table does it matter a lot (the table contains 12 reals and 4 integers) ?
I found that using an intermediate table which stock for every row the value before and the value after helps to gain speed... But it is not a very nice way i think..
Thanks again :)
Etienne
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mrblonde@locked.myftp.org, franco@akyasociados.com.ar
Subject: Re: update from multiple rows
In-Reply-To: <20050124233220.6CA161C00085@mwinf1206.wanadoo.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox