Re: [PERFORM] Improving PostgreSQL insert performance

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: [PERFORM] Improving PostgreSQL insert performance
Дата
Msg-id CAMkU=1zzG8iKP8eao_YEyB4Q2rimuEEwZO1n+TQd4PCk01FZMg@mail.gmail.com
обсуждение исходный текст
Ответ на [PERFORM] Improving PostgreSQL insert performance  (Frits Jalvingh <jal@etc.to>)
Список pgsql-performance
Дерево обсуждения
On Fri, Jun 9, 2017 at 6:04 AM, Frits Jalvingh <jal@etc.to> wrote:

I already changed the following config parameters:
work_mem 512MB
synchronous_commit off

Since you are already batching up commits into large chunks, this setting is not very useful, but does risk you losing supposedly-committed data upon a crash.  I would not do it.
 
shared_buffers 512mb

You might try increasing wal_buffers, but the default for this size of shared_buffers is 16MB, which is usually big enough.
 
One thing you are missing is max_wal_size.  The default value of that is probably too small for what you are doing.

But if you are not using COPY, then maybe none of this matters as the bottleneck will be elsewhere.

Cheers,

Jeff

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

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