Skip to main content
2 votes

Merging PostGIS tables with billions of rows

Is CTE + union all + case statements the best way to join multiple tables? You can simplify that to just two full joins: demo at db<>fiddle select*from pop.children full join pop.men using(...
Zegarek's user avatar
  • 712
1 vote

In PostgreSQL how to build polygons using lines around each dot

Polygonize all lines then inner join your points to them, and select distinct polygons: with polygonized as ( select l.id, st_makepolygon((st_dump(l.geom)).geom) as geom from test.lines as l ) select ...
Bera's user avatar
  • 74.9k
1 vote

Tiles getting generated in both PostgreSQL and gwc directory?

The disk quota database does not store tiles, it just stores a ledger of how much space the tiles use on disk, and how frequently/recently they have been accessed. When the quota is reached, this ...
Andrea Aime's user avatar
  • 17.5k

Only top scored, non community-wiki answers of a minimum length are eligible