Is there a way, how to obtain more points from raster in one query faster than this?
SELECT x, y, ST_Value(raw_data, 1, x, y) AS val_0, ST_Value(raw_data, 2, x, y) AS val_1 FROM data CROSS JOIN generate_series(1, 256) As x CROSS JOIN generate_series(1, 256) As y WHERE ((x = 184 AND y = 192) OR (x = 185 AND y = 192) OR ....)
Speed of this is the same as if I call
ST_Value for every pair manually (but that is not, what I want)
Also, I have two bands and need value from both. But ifthere is something faster for only one band data, I can separate them.