loading large amount of data

[gis-pl]

We tried to load large amount of data (300k polygons stored in PostGIS) to the map using this query:
https://github.com/doneill/koop-provider-pg/blob/main/src/db/sql/createGeoJson.sql

Unfortunately with this amount of data, it freezes PostGIS and it needs to be restarted.
Is it possible not to load all objects, but only a small portion, for example - only polygons that are displayed in the extent of the map by user?

[doneill]

Good suggestion, currently the provider attempts to fetch all geometries. Thanks for sharing the limitation, will do some testing with large datasets and look to area extent limitations