Re: Improve performance for writing

Поиск
Список
Период
Сортировка
От Charles Gomes
Тема Re: Improve performance for writing
Дата
Msg-id BLU002-W186694D3F0E283029B6501DAB380@phx.gbl
обсуждение исходный текст
Ответ на Improve performance for writing  (Markus Innerebner <markus.innerebner@inf.unibz.it>)
Список pgsql-performance
Markus,

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


----------------------------------------
> From: markus.innerebner@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
geometryattribute) 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Markus Innerebner
Дата:
Сообщение: Improve performance for writing
Следующее
От: Charles Gomes
Дата:
Сообщение: Re: Performance on Bulk Insert to Partitioned Table