gresql.org
Subject: RE: postgres backend process hang on " D " state
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
Sent: Monday, May 30, 2022 10:21 AM
To: James
Subject: Re: postgres backend process hang on " D " state
"James Pang (chaolpan)" 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
-performance@lists.postgresql.org
Subject: Re: postgres backend process hang on " D " state
On Mon, May 30, 2022 at 01:19:56AM +, James Pang (chaolpan) wrote:
> 1. extensions
> shared_preload_libraries =
> 'orafce,pgaudit,pg_cron,pg_stat_statements,set_user'
>
"James Pang (chaolpan)" 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
On Mon, May 30, 2022 at 01:19:56AM +, James Pang (chaolpan) wrote:
> 1. extensions
> shared_preload_libraries =
> 'orafce,pgaudit,pg_cron,pg_stat_statements,set_user'
> 2. psql can not login now ,it hang there too, so can not check anything from
> pg_stats_* views
> 3. one main app u
Original Message-
From: Justin Pryzby
Sent: Sunday, May 29, 2022 11:02 PM
To: James Pang (chaolpan)
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: postgres backend process hang on " D " state
On Sun, May 29, 2022 at 01:20:12PM +, James Pang (chaolpan) wrote:
>
On Sun, May 29, 2022 at 01:20:12PM +, James Pang (chaolpan) wrote:
>We have a performance test on Postgresql 13.4 on RHEL8.4 , just after
> connection storm in ( 952 new connections coming in 1 minute), a lot of
> backends start on " D " state, and when more sessions got disconnected, t
Em dom., 29 de mai. de 2022 às 10:20, James Pang (chaolpan) <
chaol...@cisco.com> escreveu:
> Hi,
>
>We have a performance test on Postgresql 13.4 on RHEL8.4 ,
>
Hard to say with this info, but how is this " test", why not use the 13.7,
with all bugs fixes related?
regards,
Ranier Vilela
>
