Re: PostgreSQL performance problem moving from 9.6.17 to 12.3

2020-05-28 Thread Tom Lane
Kenneth Marshall writes: > I have a system that was running version 9.6.17 running on a system with > 48gb of memory and spinning disks front-ed by a HW RAID controller with > NVRAM cache. We moved to a new box running version 12.3 on a system with > 64gb of memory and NVME SSD drives. Here are th

PostgreSQL performance problem moving from 9.6.17 to 12.3

2020-05-28 Thread Kenneth Marshall
Hi PostgreSQL community, I have a system that was running version 9.6.17 running on a system with 48gb of memory and spinning disks front-ed by a HW RAID controller with NVRAM cache. We moved to a new box running version 12.3 on a system with 64gb of memory and NVME SSD drives. Here are the system