I want to bypass any disk bottleneck so I store all the data in ramfs (the purpose the project is to profile pg so I don't care for data loss if anything goes wrong).
Since my data are memory resident, I thought the size of the shared buffers wouldn't play much role, yet I have to admit that I saw difference in performance when modifying shared_buffers parameter.
I use taskset to control the number of cores that PostgreSQL is deployed on.
Is there any parameter/variable in the system that is set dynamically and depends on the number of cores ?
Cheers,
Dimitris