Parallel Index Scan Implementation

From: Brajendra Pratap Singh <singh(dot)bpratap766(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Parallel Index Scan Implementation
Date: 2023-11-26 13:51:15
Message-ID: CAFD-joN2OFbByFhkB=GnDBiAaS8VuYwSf-SgS3G6j2bEEuxg9A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Les 2023-11-26 16:16:12 Re: replication primary writting infinite number of WAL files
Previous Message Ron Johnson 2023-11-26 12:17:03 Re: pg_getnameinfo_all() failed: Temporary failure in name resolution