Postgres Pro
Downloads
Home   >   mailing lists

RE: [ext] Re: Pointers towards identifying bulk import bottleneck(walwriter tuning?) - Mailing list pgsql-general

From Holtgrewe, Manuel
Subject RE: [ext] Re: Pointers towards identifying bulk import bottleneck(walwriter tuning?)
Date
Msg-id CC941ED861F3AA469B6D50EE76C57483015EAC0D75@s-mx14-bih01.charite.de
Whole thread Raw
In response to Re: Pointers towards identifying bulk import bottleneck (walwriter tuning?)  (Luca Ferrari <fluca1978@gmail.com>)
Responses 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>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Lev Kokotov
Date:
Subject: Include a connection pooler in Postgres
Next
From: Adrian Klaver
Date:
Subject: Re: Include a connection pooler in Postgres