Re: HIGH IO and Less CPU utilization

On Wed, Mar 30, 2022 at 10:17:38AM +0530, Rambabu g wrote: > Hi Justin, > > Only one query is causing the issue, sharing the def of indexes. Please > have a look. > > > > There are three indexes defined on the table, each one is around 20 to > > > 25GB > > tp| character varying(2000) | y

RE: High process memory consumption when running sort

Thanks a lot Justin, I used the link that you shared and I noticed that in most cases, when I was simulating the issue with simple SQL's, most of the RSS was actually shared. e.g. from /proc/pid/status RssAnon:8672 kB RssFile:4576 kB RssShmem:4596656 kB