Pessoal, preciso jogar no postgresql varios comando de explain, como estao
abaixo( uns 40) mas da o seguinte erro, depois de processar alguns
--------------------------------------------------------------------
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
--------------------------------------------------------
Alguem saberia falar que configuração poderia alterar para não acontecer
isso? segue os comandos, são da base de dados benchmark DBT2.
EXPLAIN DECLARE mycursor CURSOR FOR SELECT new_order(1, 6, 2496, 1, 8,
make_new_order_info(86000, 1, 8), make_new_order_info(52206, 1, 2),
make_new_order_info(10111, 1, 4), make_new_order_info(87936, 1, 8),
make_new_order_info(16384, 1, 9), make_new_order_info(60414, 1, 5),
make_new_order_info(540, 1, 8), make_new_order_info(36219, 1, 5),
make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0),
make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0),
make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0),
make_new_order_info(0, 0, 0) );
EXPLAIN DECLARE mycursor CURSOR FOR SELECT new_order(1, 7, 990, 1, 9,
make_new_order_info(39388, 1, 1), make_new_order_info(4660, 1, 2),
make_new_order_info(64208, 1, 1), make_new_order_info(14333, 1, 4),
make_new_order_info(79360, 1, 2), make_new_order_info(82944, 1, 5),
make_new_order_info(2013, 1, 4), make_new_order_info(84992, 1, 4),
make_new_order_info(49087, 1, 1), make_new_order_info(0, 0, 0),
make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0),
make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0),
make_new_order_info(0, 0, 0) );
EXPLAIN SELECT payment(1, 9, 0, 1, 9, 'ABLEPRESPRI', 346.130000);
EXPLAIN DECLARE mycursor CURSOR FOR SELECT new_order(1, 10, 72, 1, 11,
make_new_order_info(90111, 1, 1), make_new_order_info(96255, 1, 6),
make_new_order_info(99310, 1, 2), make_new_order_info(92922, 1, 3),
make_new_order_info(57032, 1, 2), make_new_order_info(79359, 1, 2),
make_new_order_info(83766, 1, 5), make_new_order_info(81788, 1, 9),
make_new_order_info(79743, 1, 7), make_new_order_info(47616, 1, 8),
make_new_order_info(40956, 1, 1), make_new_order_info(0, 0, 0),
make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0),
make_new_order_info(0, 0, 0) );
Qualquer ajuda é bem vinda!!!
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
