Versão atualizada pra 9.3.12. O problema aparentemente foi corrigido. Fiz os mesmos testes .
[QUERY ] VACUUM FULL analyze verbose jbpm_byteblock INFO: vacuuming "public.jbpm_byteblock" INFO: "jbpm_byteblock": found 8994 removable, 18829714 nonremovable row versions in 2620337 pages DETAIL: 0 dead row versions cannot be removed yet. CPU 71.97s/27.34u sec elapsed 231.67 sec. INFO: analyzing "public.jbpm_byteblock" INFO: "jbpm_byteblock": scanned 300000 of 2619065 pages, containing 2158397 live rows and 0 dead rows; 300000 rows in sample, 18831267 estimated total rows [QUERY ] VACUUM FULL analyze verbose jbpm_variableinstance INFO: vacuuming "public.jbpm_variableinstance" INFO: "jbpm_variableinstance": found 679 removable, 12736203 nonremovable row versions in 225672 pages DETAIL: 0 dead row versions cannot be removed yet. CPU 5.43s/8.46u sec elapsed 14.66 sec. INFO: analyzing "public.jbpm_variableinstance" INFO: "jbpm_variableinstance": scanned 225654 of 225654 pages, containing 12736203 live rows and 0 dead rows; 300000 rows in sample, 12736203 estimated total rows
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral