Maybe any bugs from these extensions ? I can try that removing all extensions, but we need these extensions.
Thanks, James -----Original Message----- From: Tom Lane <t...@sss.pgh.pa.us> Sent: Monday, May 30, 2022 10:21 AM To: James Pang (chaolpan) <chaol...@cisco.com> Cc: Justin Pryzby <pry...@telsasoft.com>; pgsql-performance@lists.postgresql.org Subject: Re: postgres backend process hang on " D " state "James Pang (chaolpan)" <chaol...@cisco.com> writes: > 1. extensions > shared_preload_libraries = > 'orafce,pgaudit,pg_cron,pg_stat_statements,set_user' Can you still reproduce this if you remove all of those? regards, tom lane