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
