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 <tgl@xxxxxxxxxxxxx> Sent: Monday, May 30, 2022 10:21 AM To: James Pang (chaolpan) <chaolpan@xxxxxxxxx> Cc: Justin Pryzby <pryzby@xxxxxxxxxxxxx>; pgsql-performance@xxxxxxxxxxxxxxxxxxxx Subject: Re: postgres backend process hang on " D " state "James Pang (chaolpan)" <chaolpan@xxxxxxxxx> 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
