Re: postgres backend process hang on " D " state

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: postgres backend process hang on " D " state
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Sun, 29 May 2022 22:21:07 -0400
Cc: Justin Pryzby <pryzby@xxxxxxxxxxxxx>, "pgsql-performance@xxxxxxxxxxxxxxxxxxxx" <pgsql-performance@xxxxxxxxxxxxxxxxxxxx>
Comments: In-reply-to "James Pang (chaolpan)" <chaolpan@xxxxxxxxx> message dated "Mon, 30 May 2022 01:19:56 -0000"
In-reply-to: <PH0PR11MB5191C0B3BE53A16AC7EED9FED6DD9@PH0PR11MB5191.namprd11.prod.outlook.com>
References: <PH0PR11MB5191521AF97E422D288DB9DBD6DA9@PH0PR11MB5191.namprd11.prod.outlook.com> <20220529150157.GM19626@telsasoft.com> <PH0PR11MB5191C0B3BE53A16AC7EED9FED6DD9@PH0PR11MB5191.namprd11.prod.outlook.com>

"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

Follow-Ups:
- RE: postgres backend process hang on " D " state
  - From: James Pang (chaolpan)

References:
- postgres backend process hang on " D " state
  - From: James Pang (chaolpan)
- Re: postgres backend process hang on " D " state
  - From: Justin Pryzby
- RE: postgres backend process hang on " D " state
  - From: James Pang (chaolpan)

Prev by Date: Re: postgres backend process hang on " D " state
Next by Date: RE: postgres backend process hang on " D " state
Previous by thread: RE: postgres backend process hang on " D " state
Next by thread: RE: postgres backend process hang on " D " state
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux