On Thu, Jun 22, 2017 at 6:54 AM, Andres Freund <and...@anarazel.de> wrote: > On 2017-06-21 00:57:32 -0700, jasrajd wrote: >> We are also seeing contention on the walwritelock and repeated writes to the >> same offset if we move the flush outside the lock in the Azure environment. >> pgbench doesn't scale beyond ~8 cores without saturating the IOPs or >> bandwidth. Is there more work being done in this area? >
That should not happen if the writes from various backends are combined in some way. However, it is not very clear what exactly you have done as part of taking flush calls out of walwritelock. Can you share patch or some details about how you have done it and how have you measured the contention you are seeing? -- With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers