Opened 4 years ago

Closed 4 years ago

#3556 closed enhancement (fixed)

Parallelization of Basic raster functions for PostgreSQL 9.6

Reported by: robe Owned by: robe
Priority: medium Milestone: PostGIS 2.3.0
Component: raster Version: master
Keywords: history Cc:

Description

I think a good chunk of functions in PostGIS raster can be parallelized. Particularly the ones like the ST_MapAlgebra, ST_Reclass family that take one raster per row and transform to anothr raster.

Sadly I think the aggregates are a lost cause for 9.6.

Anyrate I'm going to experiment to flag which ones can be marked parallel safe and putting proper costing on them.

Being able to commit this work would hinge on #3549

Change History (6)

comment:1 Changed 4 years ago by robe

In 14937:

Mark stable and immutable strict functions as parallel safe
references #3556

comment:2 Changed 4 years ago by robe

Keywords: history added
Resolution: fixed
Status: newclosed

I'm going to mark this as done. I still have testing to do but that is more of a task than anything.

comment:3 Changed 4 years ago by robe

Resolution: fixed
Status: closedreopened
Type: defectenhancement

I thought I had finished this but I see I'm missing some key ones.

comment:4 Changed 4 years ago by robe

In 15126:

mark more raster functions parallel safe
references #3556

comment:5 Changed 4 years ago by robe

I'm having some issues getting Parallelization to kick in for raster despite my efforts. geometry looks really good. Still need to test geography.

comment:6 Changed 4 years ago by robe

Resolution: fixed
Status: reopenedclosed
Note: See TracTickets for help on using tickets.