It is part of GML specification. I have an idea of doing a count estimate for postgis, kind of like the box estimate. It would only break the spec a little as long as the answer is higher (until the last page when we would know for sure).
Can you try a different format that does not require count? -- Jody Garnett On Sun, Jun 16, 2024 at 10:54 PM Carsten Klein <c.kl...@datagis.com> wrote: > Dear all, > > is there a way to prevent GeoServer from issuing a count(*) on a layer's > table (using PostGIS) for every GetFeature WFS request? > > Those tables have > 50 million rows. The query itself, which is quite > simple, is very fast as it's using an index (0.1 sec). However, including > the count(*) performed by GeoServer, the overall request time is ~3 secs. > > Any advise is highly appreciated. > > Carsten > > > -- > > Carsten Klein > Lead Software Engineer > > DataGis GmbH > > Johann-Strauß-Str. 26 > <https://www.google.com/maps/search/Johann-Strau%C3%9F-Str.+26+%0D%0A++++++++70794+Filderstadt?entry=gmail&source=g> > 70794 Filderstadt > <https://www.google.com/maps/search/Johann-Strau%C3%9F-Str.+26+%0D%0A++++++++70794+Filderstadt?entry=gmail&source=g> > > T +49 7158 9490-106 > F +49 7158 9490-111 > > E-Mail: c.kl...@datagis.com > Internet: www.datagis.com > > Registergericht: Amtsgericht Stuttgart, HRB 225945 > Geschäftsführung: Dr. Gunter Hahn, Markus Ruess, Carsten Klein > _______________________________________________ > Geoserver-users mailing list > > Please make sure you read the following two resources before posting to > this list: > - Earning your support instead of buying it, but Ian Turton: > http://www.ianturton.com/talks/foss4g.html#/ > - The GeoServer user list posting guidelines: > http://geoserver.org/comm/userlist-guidelines.html > > If you want to request a feature or an improvement, also see this: > https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer > > > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users >
_______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
