Re: Improve performance for writing

Markus,

Have you looked over here:
http://www.postgresql.org/docs/9.2/static/populate.html

----------------------------------------
> From: markus(dot)innerebner(at)inf(dot)unibz(dot)it
> Subject: [PERFORM] Improve performance for writing
> Date: Thu, 27 Dec 2012 14:10:40 +0100
> To: pgsql-performance(at)postgresql(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance