<span style="font-size: 12pt;">________________________________</span><br>>
Date: Fri, 12 Sep 2014 09:48:53 -0300 <br>> From: [email protected]
<br>> To: [email protected] <br>> Subject: [pgbr-geral]
Limite de cursores <br>> <br>> Bom dia, estou configurando um pool de
conexões pelo servidor de <br>> aplicações wildfly 8.1.0 <br><br>Por
curiosidade, qual é a relação disso com o máximo de cursores
abertos?<br><br>> e me deparei com a seguinte advertência na documentação:
<br>> <br>> Statement Cache Size <br>> <br>> The Statement Cache
Size attribute determines the total number of <br>> prepared and callable
statements to cache for each connection in each <br>> instance of the data
source. By caching statements, you can increase <br>> your system
performance. However, you must consider how your DBMS <br>> handles open
prepared and callable statements. In many cases, the DBMS <br>> will
maintain a cursor for each open statement. This applies to <br>> prepared
and callable statements in the statement cache. If you cache <br>> too many
statements, you may exceed the limit of open cursors on your <br>> database
server. <br><br>Será que tem relação com o
max_prepared_transactions[1]?<br><br>[1] <a
href="http://www.postgresql.org/docs/9.3/static/runtime-config-resource.html#GUC-MAX-PREPARED-TRANSACTIONS";
target="_blank">http://www.postgresql.org/docs/9.3/static/runtime-config-resource.html#GUC-MAX-PREPARED-TRANSACTIONS</a><div><br><br>Sebastian
Webber<br>http://swebber.me<br></div>
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
