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
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
