Sampling of points at lower zoom. about pg_tileserv HOT 2 CLOSED

Or a view.

Or for performance, add a column of random values, rewrite your data in that order, and put a BRIN index on it. Then use randomkey < 0.2 or something like that.

CREATE TABLE points_rnd AS
  SELECT random(),*
   FROM points
   ORDER BY 1;
   
 CREATE INDEX points_rnd_x ON points_rnd USING BRIN (random);

from pg_tileserv.

Yes, currently CQL filters don't support functions. It would be nice if they did.

Can you use a function layer to accomplish this?

from pg_tileserv.