Re: Parallel bitmap index scan

2020-12-22 Thread Dilip Kumar
On Wed, 23 Dec 2020 at 4:15 AM, Tomas Vondra wrote: > On 11/11/20 8:52 PM, Tomas Vondra wrote: > > Hi, > > > > I took a look at this today, doing a bit of stress-testing, and I can > > get it to crash because of segfaults in pagetable_create (not sure if > > the issue is there, it might be just a

Re: Parallel bitmap index scan

2020-12-22 Thread Tomas Vondra
On 11/11/20 8:52 PM, Tomas Vondra wrote: > Hi, > > I took a look at this today, doing a bit of stress-testing, and I can > get it to crash because of segfaults in pagetable_create (not sure if > the issue is there, it might be just a symptom of an issue elsewhere). > > Attached is a shell script

Re: Parallel bitmap index scan

2020-11-11 Thread Tomas Vondra
Hi, I took a look at this today, doing a bit of stress-testing, and I can get it to crash because of segfaults in pagetable_create (not sure if the issue is there, it might be just a symptom of an issue elsewhere). Attached is a shell script I use to run the stress test - it's using 'test' databa

Re: Parallel bitmap index scan

2020-09-20 Thread Dilip Kumar
On Sun, Jul 26, 2020 at 6:42 PM Dilip Kumar wrote: > > I would like to propose a patch for enabling the parallelism for the > bitmap index scan path. > > Background: > Currently, we support only a parallel bitmap heap scan path. Therein, > the underlying bitmap index scan is done by a single work

Re: Parallel bitmap index scan

2020-08-17 Thread Dilip Kumar
On Mon, 17 Aug 2020 at 7:42 PM, Bharath Rupireddy < bharath.rupireddyforpostg...@gmail.com> wrote: > On Sun, Jul 26, 2020 at 6:43 PM Dilip Kumar wrote: > > > > > > I would like to propose a patch for enabling the parallelism for the > > > bitmap index scan path. > > > > > > Background: > > > Curr

Re: Parallel bitmap index scan

2020-08-17 Thread Bharath Rupireddy
On Sun, Jul 26, 2020 at 6:43 PM Dilip Kumar wrote: > > I would like to propose a patch for enabling the parallelism for the > bitmap index scan path. > > Background: > Currently, we support only a parallel bitmap heap scan path. Therein, > the underlying bitmap index scan is done by a single work

Re: Parallel bitmap index scan

2020-07-28 Thread Dilip Kumar
On Mon, Jul 27, 2020 at 3:48 AM Thomas Munro wrote: > > On Mon, Jul 27, 2020 at 1:58 AM Dilip Kumar wrote: > > On Sun, Jul 26, 2020 at 6:42 PM Dilip Kumar wrote: > > > > > > I would like to propose a patch for enabling the parallelism for the > > > bitmap index scan path. > > Wor

Re: Parallel bitmap index scan

2020-07-26 Thread Dilip Kumar
On Mon, 27 Jul 2020 at 3:48 AM, Thomas Munro wrote: > On Mon, Jul 27, 2020 at 1:58 AM Dilip Kumar wrote: > > On Sun, Jul 26, 2020 at 6:42 PM Dilip Kumar > wrote: > > > > > > I would like to propose a patch for enabling the parallelism for the > > > bitmap index scan path. > > Wo

Re: Parallel bitmap index scan

2020-07-26 Thread Thomas Munro
On Mon, Jul 27, 2020 at 1:58 AM Dilip Kumar wrote: > On Sun, Jul 26, 2020 at 6:42 PM Dilip Kumar wrote: > > > > I would like to propose a patch for enabling the parallelism for the > > bitmap index scan path. Workers Planned: 4 -> Parallel Bitmap Heap Scan on ten

Re: Parallel bitmap index scan

2020-07-26 Thread Dilip Kumar
On Sun, Jul 26, 2020 at 6:42 PM Dilip Kumar wrote: > > I would like to propose a patch for enabling the parallelism for the > bitmap index scan path. > > Background: > Currently, we support only a parallel bitmap heap scan path. Therein, > the underlying bitmap index scan is done by a single work