Thread: Still need GUC update_process_title?

Still need GUC update_process_title?

From
Bruce Momjian
Date:
We added GUC update_process_title (default is 'on') in 8.2 based on
tests Tom ran showing that there was a performance impact for the
process title.  With the new use of strlcpy(), is there still an impact
from process title?  Tom, would you run your tests again?  Thanks.

--  Bruce Momjian   bruce@momjian.us EnterpriseDB    http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


Re: Still need GUC update_process_title?

From
Tom Lane
Date:
Bruce Momjian <bruce@momjian.us> writes:
> We added GUC update_process_title (default is 'on') in 8.2 based on
> tests Tom ran showing that there was a performance impact for the
> process title.  With the new use of strlcpy(), is there still an impact
> from process title?  Tom, would you run your tests again?  Thanks.

I don't really need to: the platforms on which it counts are the ones
where a kernel call is involved.  It's sheer folly to suppose that
strlcpy eliminates that issue.
        regards, tom lane