On Wed, Sep 6, 2017 at 9:16 AM, Haribabu Kommi <kommi.harib...@gmail.com> wrote: > > Attached the latest patch and performance report. > While looking into the patch, I realized that a normal backend has to check almost 10 if conditions at worst case inside XLogWrite(6 in am_background_process method, 1 for write, 1 for blocks, 2 for fsyncs), just to decide whether it is a normal backend or not. The count is more for walwriter process. Although I've not done any performance tests, IMHO, it might add further overhead on the XLogWrite Lock.
I was thinking whether it is possible to collect all the stats in XLogWrite() irrespective of the type of backend and update the shared counters at once at the end of the function. Thoughts? -- Thanks & Regards, Kuntal Ghosh 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