Re: [PERFORM] Improving PostgreSQL insert performance

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: [PERFORM] Improving PostgreSQL insert performance
Дата
Msg-id 20170611023214.r2yucev656ojv3pi@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: [PERFORM] Improving PostgreSQL insert performance  (Frits Jalvingh <jal@etc.to>)
Ответы Re: [PERFORM] Improving PostgreSQL insert performance  (Joe Conway <mail@joeconway.com>)
Re: [PERFORM] Improving PostgreSQL insert performance  (Frits Jalvingh <jal@etc.to>)
Список pgsql-performance
Frits Jalvingh wrote:

> So, I am still very interested in getting normal inserts faster, because
> that will gain speed for all work.. If Oracle can do it, and Postgres is
> able to insert fast with copy- where lies the bottleneck with the insert
> command? There seems to be quite a performance hit with the JDBC driver
> itself (as the stored procedure is a lot faster), so I can look into that.
> But even after that there is quite a gap..

Did you try inserting multiple tuples in one command?  Something like
INSERT INTO .. VALUES ('col1', 'col2'), ('col1', 'col2'), ('col1', 'col2')
It's supposed to be faster than single-row inserts, though I don't
know by how much.

--
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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

Предыдущее
От: Frits Jalvingh
Дата:
Сообщение: Re: [PERFORM] Improving PostgreSQL insert performance
Следующее
От: Joe Conway
Дата:
Сообщение: Re: [PERFORM] Improving PostgreSQL insert performance