vijay750

Hi @Deepesh125 if you work for AWS, I have a working test case which shows this cpu spike on an instance in my account. We have tracked down the origin...

It is easily reproducible - set up an aurora cluster with babelfish, and contrast the cpu usage as reported by performance insights for the bbf port vs the PG port....

@suprio-amzn you have COMPLETELY missed the point of the bug report. It was precisely to say that there is a big difference in connection overhead when connecting on bbf port...

@jsudrik a plausible clause is that in the call stack to implement the `USE` statement, a call is made to `get_authid_user_ext_physical_name()` in file session.c. In this, there is the following...

@tanscorpio7 I have added a way to reproduce this issue on a fresh db, with only one user: https://github.com/babelfish-for-postgresql/babelfish_extensions/issues/4118#issuecomment-3485228703