Hi Team, I have using postgresql server v12.2 on CentOS Linux release 7.3.1611 (Core).
My application is working fine with non partition tables but recently we are trying to adopt partition table on few of application tables. So we have created List partition on 6 table. 2 out of 6 tables have 24 partitions and 4 out of 6 tables have 500 list partitions. After performing partition table, we are trying to run our application it is getting crash as I can see the memory utilization is consumed 100% and once it reach to 100% Postgres server getting crash with following error 2020-06-09 00:47:41.876 IDT pid:9701 xid:0 ip:10.247.150.107 WARNING: terminating connection because of crash of another server process 2020-06-09 00:47:41.876 IDT pid:9701 xid:0 ip:10.247.150.107 DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2020-06-09 00:47:44.606 IDT pid:9701 xid:0 ip: HINT: In a moment you should be able to reconnect to the database and repeat your command. 2020-06-09 00:47:41.876 IDT pid:9961 xid:0 ip:10.247.150.107 FATAL: the database system is in recovery mode Prior to partition changes Postgres server utilizing 30% of total memory. Does number of partition is impacting the memory utilization? My configuration as follows PG version 12.2 RAM on Server : 78GB effective_cache_size 44GB Shared_buffers 21GB 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 <https://www.amdocs.com/about/email-terms-of-service>
