Postgres/PostGIS integration

[alxmrs]

https://overcast.fm/+AAU1XJb7r0Y/9:25

Can Xarrat/Zarr be hooked up to PostGIS as out DB rasters?

Some notes:

• raster2pg
• 8kb page size, 32x32 pixels.
• Want a tile size to match your expected query size

[alxmrs]

• postgisRaster

[alxmrs]

Storage module (tiles) is bottleneck; lack of elastic parallelism.

https://overcast.fm/+AAU1XJb7r0Y/23:07

[alxmrs]

Further down this clip: row focus in query plan means a lack of efficient parallelism with raster data. To me, there is an analogy with Dask indexes, and the creation of special “pivoted raster” indexes as in #26 (comment).

[alxmrs]

It looks like TimeScale DB may be a good skew if Postgres to test an Xarray integration; they seem to have adopted a Zarr-like data model within Postgres internals.

https://github.com/timescale/docs.timescale.com-content/blob/master/introduction/architecture.md

[cisaacstern]

Second time timescale has come across my radar this week; haven't looked into it yet but intrigued!