RE: [ext] Re: Pointers towards identifying bulk import bottleneck(walwriter tuning?)

Поиск
Список
Период
Сортировка
От Holtgrewe, Manuel
Тема RE: [ext] Re: Pointers towards identifying bulk import bottleneck(walwriter tuning?)
Дата
Msg-id CC941ED861F3AA469B6D50EE76C57483015EAC0D75@s-mx14-bih01.charite.de
обсуждение исходный текст
Ответ на Re: Pointers towards identifying bulk import bottleneck (walwriter tuning?)  (Luca Ferrari <fluca1978@gmail.com>)
Ответы Re: [ext] Re: Pointers towards identifying bulk import bottleneck(walwriter tuning?)  (Jeff Janes <jeff.janes@gmail.com>)
Re: [ext] Re: Pointers towards identifying bulk import bottleneck(walwriter tuning?)  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-general
Hi,

I also tried creating the table as "UNLOGGED" which led to walwriter I/O to drop drastically and I now get no
wall-clocktime increase with two import processes but it gets slower with four. 

Switching off fsync leads to a drastic time improvement but still higher wall-clock time for four threads.

Thanks for the pointer to the other mailing list. I'll try my luck there.

Cheers,
Manuel


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

Предыдущее
От: Lev Kokotov
Дата:
Сообщение: Include a connection pooler in Postgres
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Include a connection pooler in Postgres