Something like that. This assumes your Dockerfile is at the same level as your docker-compose.yml. The ...
Got here from a random google search. Got curious/worried.
Takes about 2 seconds for me.
user system elapsed
0.699 0.077 2.119
PostgreSQL 11.10 (Ubuntu 11.10-1.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit
So far, I have not found more efficient solutions for my calculations on PostGIS. Due to memory limits, even the queries searching for total number of cells of a given value could not be run entirely. A solution would have consisted in splitting the raster extent into several parts, running the queries for these separate parts and merging the results (by ...