Bom dia, estou configurando um pool de conexões pelo servidor de aplicações wildfly 8.1.0 e me deparei com a seguinte advertência na documentação:
Statement Cache Size The Statement Cache Size attribute determines the total number of prepared and callable statements to cache for each connection in each instance of the data source. By caching statements, you can increase your system performance. However, you must consider how your DBMS handles open prepared and callable statements. In many cases, the DBMS will maintain a cursor for each open statement. This applies to prepared and callable statements in the statement cache. If you cache too many statements, *you may exceed the limit of open cursors on your database server*. Existe algum limite de cursores no Postgres? Atenciosamente, Alessandro Lima email [email protected]
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
