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 Pang (chaolpan) Cc: Justin Pryzby ; pgsql-performance@lists.postgresql.org S

RE: postgres backend process hang on " D " state

Update your questions . time find /pgdata /pgarchive /pgwal -ls |wc 82165 903817 8397391 real0m1.120s user0m0.432s sys 0m0.800s ps -u postgres -O wchan= PID S TTY TIME COMMAND 1951 -

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

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' > 2. psql can not login now ,it hang there too, so can not check anything from > pg_stats_* views > 3. one main app u

RE: postgres backend process hang on " D " state

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 user and 2 schemas ,no long running transactions . 4. we use /pgdata , it's on xfs

Re: postgres backend process hang on " D " state

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

Re: postgres backend process hang on " D " state

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 >

postgres backend process hang on " D " state

Hi, 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, they do not exit successfully, instead became "defunct". No errors fro