On 12-09-2014 10:50, Sebastian Webber wrote: > <span style="font-size: > 12pt;">________________________________</span><br>> Date: Fri, 12 Sep 2014 > 09:48:53 -0300 <br>> From: grandegoia...@gmail.com <br>> To: > pgbr-geral@listas.postgresql.org.br <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 fo r 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> >
Por favor, prefira enviar para lista mensagens somente texto... Att, -- Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
signature.asc
Description: OpenPGP digital signature
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
