Postgres Pro
Downloads
Home   >   mailing lists

Parallel Index Scan Implementation - Mailing list pgsql-general

From Brajendra Pratap Singh
Subject Parallel Index Scan Implementation
Date
Msg-id CAFD-joN2OFbByFhkB=GnDBiAaS8VuYwSf-SgS3G6j2bEEuxg9A@mail.gmail.com
Whole thread Raw
Responses Re: Parallel Index Scan Implementation
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: pg_getnameinfo_all() failed: Temporary failure in name resolution
Next
From: Les
Date:
Subject: Re: replication primary writting infinite number of WAL files