Markus,
Have you looked over here:
http://www.postgresql.org/docs/9.2/static/populate.html
From: markus.innereb...@inf.unibz.it
Subject: [PERFORM] Improve performance for writing
Date: Thu, 27 Dec 2012 14:10:40 +0100
To: pgsql-performance@postgresql.org
Hello
please do not consider this email as an yet another question how to speed up
writing.
The situation is different:
My algorithm stores after the computation the result as tuples in a DB.
The tuples in addition to normal values (e.g. a,b) , contains sql statements
that fetch values (for instance the geometry attribute) from another table
(e.g. orig_table).
e.g.
INSERT INTO dest_table (
Select a,b, s.geometry,s.length from orig_table s where s.id=?
)
The number of inserts depends on the size of the result and vary from 10,000
to 1,000,000.
My question is: how can I speed up such inserts?
Only COPY statements want work, since I need additional values
Insert statements takes long time (even if using Bulk)
What do you suggest me in such a situation?
Would it be better to perform?
- first use COPY to store values in new table
- second update the new table with values from origin table
thanks for your hints / suggestions
cheers Markus
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance