Hi Postgresql Experts, We have a basic requirement where we need to implement the parallel index scan instead of parallel seq scan at table level. Please suggest the best way to do this.
Postgresql DB Version : 12.6 Table size : 2-5 GB OS : Centos-7 RAM : 96 GB CPU : 32 shared_buffer=20GB Effective_cache_size=60GB Max_worker_process = 32 Max_parallel_worker=32 Max_parallel_worker_per_gather=8 Please let me know if any further details required . Thanks & Regards, Singh