Hi, On 2017-09-15 17:43:35 +0530, Kuntal Ghosh wrote: > The patch looks good to me. I've done some regression testing with a > custom script on my local system. The script contains the following > statement:
> SELECT 'aaa..<repeated 600 times>' as col; > > Test 1 > ----------------------------------- > duration: 300 seconds > clients/threads: 1 > With the patch TPS:13628 (+3.39%) > + 0.36% 0.21% postgres postgres [.] pgstat_report_activity > > Test 2 > ----------------------------------- > duration: 300 seconds > clients/threads: 8 > With the patch TPS: 63949 (+20.4%) > + 0.40% 0.25% postgres postgres [.] pgstat_report_activity > > This shows the significance of this patch in terms of performance > improvement of pgstat_report_activity. Is there any other tests I > should do for the same? Thanks for the test! I think this looks good, no further tests necessary. Greetings, Andres Freund -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers