Comment by yodaarjun

This month I've been working on automating the data collection and processing for my property research website [0]. I'm testing out DuckDB to process geospatial data, and so far the process has been quite pleasant.

As long as you don't need many advanced spatial functions (where PostGIS shines), and you make sure to minimize the use of GDAL to perform operations, it parallelizes processing quite nicely (most queries on large datasets saturate as many cores as you throw at it).

[0] https://wynds.com.au