how to reduce Xidgenlock wait event

vacuum_freeze_min_age 1 vacuum_freeze_table_age 2 vacuum_multixact_freeze_min_age 1 vacuum_multixact_freeze_table_age 2 wal_buffers 262143 wal_keep_segments 400 work_mem 18432 Thanks & Regards Ishan Joshi This email and the information contained herein is proprietary

Auto vacuum not reclaiming the space and disk utilization spike to 100%

from XXX_sequence_pp18; count --- 0 Table Size External Size xxx_sequence_pp18 340 MB 74 MB I am suspecting due to this disk utilization is getting higher in my environment. Can you please help to tune such issue Thanks & Regards, Ishan Joshi This email and the information contained

RE: Postgres server 12.2 crash with process exited abnormally and possibly corrupted shared memory

going to number of partition only. How can we check the memory utilization by a table object or a specific query ? Thanks & Regards, Ishan Joshi From: Ishan Joshi Sent: Wednesday, June 10, 2020 10:42 PM To: Michael Lewis Cc: pgsql-gene...@postgresql.org Subject: RE: Postgres server 12.2 c

RE: Postgres server 12.2 crash with process exited abnormally and possibly corrupted shared memory

constant 70% RAM utilization and 50% cpu utilization. So I am suspecting the number of partition is the issue behind the memory utilization. Thanks & Regards, Ishan Joshi From: Michael Lewis Sent: Wednesday, June 10, 2020 10:28 PM To: Ishan Joshi Cc: pgsql-gene...@postgresql.org Subject

RE: Postgres server 12.2 crash with process exited abnormally and possibly corrupted shared memory

s=off. Thanks & Regards, Ishan Joshi From: Michael Lewis Sent: Wednesday, June 10, 2020 1:23 AM To: Ishan Joshi Cc: pgsql-gene...@postgresql.org Subject: Re: Postgres server 12.2 crash with process exited abnormally and possibly corrupted shared memory On Tue, Jun 9, 2020 at 8:35 AM Ishan Jos

Postgres server 12.2 crash with process exited abnormally and possibly corrupted shared memory

max_connections 2000 work_mem 9MB max_worker_processes 24 Thanks & Regards, Ishan Joshi This email and the information contained herein is proprietary and confidential and subject to the Amdocs Email Terms of Service, which you may review at https://www.amdocs.com/about/email-terms-of-service &l

RE: idle_in_transaction_session_timeout not getting log in PG v12.2

nd did you restart the 12 server after? --> copy and restart the server 12 4) What is being logged to the file e.g. connections/disconnects, etc? --> yes these are getting logged Thanks & Regards, Ishan Joshi -Original Message- From: Adrian Klaver Sent: Tuesday, May

RE: idle_in_transaction_session_timeout not getting log in PG v12.2

Yes Adrian...!!! Thanks & Regards, Ishan Joshi -Original Message- From: Adrian Klaver Sent: Tuesday, May 19, 2020 7:53 PM To: Ishan Joshi ; pgsql-gene...@postgresql.org Subject: Re: idle_in_transaction_session_timeout not getting log in PG v12.2 On 5/19/20 7:12 AM, Ishan Joshi w

RE: idle_in_transaction_session_timeout not getting log in PG v12.2

logging_collector on Thanks & Regards, Ishan Joshi -Original Message- From: Adrian Klaver Sent: Tuesday, May 19, 2020 7:28 PM To: Ishan Joshi ; pgsql-gene...@postgresql.org Subject: Re: idle_in_transaction_session_timeout not getting log in PG v12.2 On 5/19/20 2:08 AM, Ishan Joshi w

idle_in_transaction_session_timeout not getting log in PG v12.2

ating logs. Thanks & Regards, Ishan Joshi This email and the information contained herein is proprietary and confidential and subject to the Amdocs Email Terms of Service, which you may review at https://www.amdocs.com/about/email-terms-of-service <https://www.amdocs.com/about/email-terms-of-service>