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

From: "Holtgrewe, Manuel" <manuel(dot)holtgrewe(at)bihealth(dot)de>
To: Luca Ferrari <fluca1978(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: RE: [ext] Re: Pointers towards identifying bulk import bottleneck (walwriter tuning?)
Date: 2019-08-27 14:43:18
Message-ID: CC941ED861F3AA469B6D50EE76C57483015EAC0D75@s-mx14-bih01.charite.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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-clock time 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-08-27 14:58:05 Re: Include a connection pooler in Postgres
Previous Message Lev Kokotov 2019-08-27 14:35:18 Include a connection pooler in Postgres