Hi,
It is not unknown to have slow counting in PostgreSQL:
https://wiki.postgresql.org/wiki/Slow_Counting and
https://www.cybertec-postgresql.com/en/postgresql-count-made-fast/
I always try to avoid using the count-parameter, as the implications don’t seem
user-friendly to me.
Regards,
Julian
Hi Marcin,
a simple count without any filter usually should not take that much time, I
suspect that there may be something else having an impact on the
performance.
That say, it is possible to deactivate the number matched count on the
layer configuration page unter the publishing tab:
On Mon, 7 Jun 2021 at 19:25, Victor.Sinceac
wrote:
> Hi,
>
> I think there is a typo in GeoTools
> (/geotools/data/jdbc/datasource/JNDIDataSourceFactory.java):
>
> public static final Param JNDI_REFNAME = new
> Param("jdniReferenceName", String.class, "The path where the connection
> pool
